Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

9i exp command / options available for 10g imp

apex_discoJun 3 2013 — edited Jun 4 2013

DB1 9.2.0.8.0
DB2 10.2.0.5

Testing import db1.dmp to DB2 database.
First import - using imp because dumpfile is from 9i exp

imp system@xyz full=y buffer=100000 file=db1.dmp log=imp_db1.log

Ran some scripts to add objects - users, tables, views, etc; populated data for additional tables.

So, now I need to refresh data from 9i. Question is how do I do it with the following in mind:

1) I do not want to remove all the additional objects - tables, views, etc that had already been built.
2) I just want to refresh data from 9i existing tables to the corresponding 10g DB tables.
3) Imp does not support table_exists_action ; what happens when I import?

imp system@xyz grants=N indexes=n rows=y full=y constraints=n buffer=100000 file=db1.dmp log=imp_db1.log

generated ALOT of unique constraint violated errors and takes forever (I think it's taking forever because it's evaluating each row for each table).

It has not finish, but, I think it doubled the data on the tables based on the count query.

Any suggestions on how to refresh data is greatly appreciated.

Thank you.