0

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.

Improve this question
3
  • 1
    How big is the database?
    – Philᵀᴹ
    Commented Feb 19, 2014 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
    Commented Feb 19, 2014 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
    Commented Feb 20, 2014 at 6:22

1 Answer 1

Reset to default
1

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 and acknowledge you have read our privacy policy.

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