I am working on a project that involves converting production data from an Oracle 7 DB to our system, which use Oracle 11g. In our other projects, we use DB link to access the other system DB, which is usually Oracle 10g. Can we have similar solution for Oracle 7?

We need a solution that can minimize down time of system.

  • 1
    How big is the database? – Philᵀᴹ Feb 19 '14 at 7:55
  • You might be able to write some external program (in Java, Python etc) that can connect to both databases and copy data between them. – Colin 't Hart Feb 19 '14 at 17:24
  • I'm at the stage of investigating and looking for a direction. So, I don't have the actual size for reference. – Stephen Wong Feb 20 '14 at 6:22

DB links are probably not going to work as a solution. Oracle7 is crazy old.

The question's facts are little limited. What types of objects (e.g., tables, stored procs, triggers, etc.) are involved? How much data? That said:

As it relates to table data, my solution would be to spool the data to text and access the text via external tables you setup in the 11g db.

In the 11g db, create the tables with the structure and referential integrity you require. It's been so long since I used Oracle7, so I don't think you can leverage DBMS_METADATA to obtain this DDL. You may have to get creative to reconstruct it.

Fill them with data as selects from the external tables.

Finally, index the new tables as desired.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.