Problem solve Get help with specific problems with your technologies, process and projects.

Can I import into Oracle 9i with imp.exe version 10g?

Is it OK that I try to import data into Oracle database version 9i with imp.exe version 10g?

My customer has Oracle 10g database, and my test database is Oracle 9i. My customer made an export of data with exp.exe version 10. I can't make an import with my imp.exe version 9 because it is a lower version.

So, I try to import data (that was exported with exp.exe version 10) with imp.exe version 10 into my 9i database, and I get an error:

IMP-00058: ORACLE error 6550 encountered
ORA-06550: line 1, column 33:
PLS-00302: component 'SET_NO_OUTLINES' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
IMP-00000: Import terminated unsuccessfully

Is it OK that I try to import data into database version 9i with imp.exe version 10g? Or should I tell my customer to make an export with exp.exe version 9i?

When crossing major versions of Oracle, always export with the lower version's export utility. The error above is common when trying to import a 10g dump file into an Oracle 9i database. At this point, you have two options. One, have your client use the 9i exp utility. Two, create a 10g database on your end, import the dump file. Then export on your end with your 9i exp utility before importing into your 9i database.

Dig Deeper on Oracle database backup and recovery

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.