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!

Export from 10g, Import into 9i

orclrunnerJan 21 2016 — edited Jan 26 2016

Source database: 10.2.0.3.0 Enterprise Edition 64-bit (Solaris 8)

Target database: 9.2.0.5.0 Enterprise Edition 64-bit (Solaris 8)

From 9i database:

SQL> show parameter compatible

NAME TYPE VALUE

---------------- ---------- ----------------

compatible string 9.2.0.0.0

My question is can I use EXPDP on the 10g database to export data and then use IMP on the 9i database to import the dump file created by 10g EXPDP?

Here is what my EXPDP command looks like:

expdp system/********** DIRECTORY=DATA_PUMP_DIR DUMPFILE=amazon_exp.dmp /
VERSION=9.2.0.0.0 LOGFILE=amazonEXPDP.log JOB_NAME=amazon_schema_exp schema=amazonuser

Here is the IMP command on 9i:

imp SYSTEM/password FROMUSER=amazonuser TOUSER=qauser FILE=amazon_exp.dmp SHOW=no TABLES=(*)

This functionality will go into a shell script. We want to import all tables, some are partitioned.

Thanks!

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 23 2016

Added on Jan 21 2016

#9i, #database-key-features, #export-import-sql-loader-external-tables

6 comments

4,175 views