Ask the Expert

Can I import into Oracle 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?

    Requires Free Membership to View

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.

This was first published in July 2007

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: