Q

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.

This was first published in July 2007

Dig deeper on Oracle database backup and recovery

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

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:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close