Migrate Oracle 7 database to Oracle 8

I have a very old database that I have recently received responsibility for migrating to Oracle 8. This database has not been taken care of and has been patched by many less responsible DBAs whenever their needs changed.

I have designed a better database (not yet implemented just in design phase) and now I'm wondering what would be the best way to migrate the old data over. I'm looking for the fastest and simplest approach. I understand my options to be a SQL script, a JDBC program, a SQLJ program or the equivalent in some other programming language. I'm sure there must also be other ways that I'm not aware of yet.

There are a lot of difference between the two databases. The old one was originally designed many years ago and now contains a lot of information that is now obsolete. It is also structured in many ways differently, for example a lot of the fields stored data redundantly. I found a lot of data stored this way that could easily be derived from other fields so they were not included in the new database.

If you have any suggestions or can tell me how you performed a similar migration please let me know.

I really appreciate any suggestions.

Thanks,
-Mark Received on Wed Oct 02 2002 - 18:37:03 CEST