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
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading