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

IMP-00010 error with import from 10g to 9i

I have an Oracle 10g dump file which I need to import to Oracle 9i. When I try to import I am getting the error "IMP-00010: not a valid export file, header failed verification."

I have an Oracle 10g dump file which I need to import to Oracle 9i. When I try to import I am getting the error message stating "IMP-00010: not a valid export file, header failed verification." Please tell me how to overcome this problem and import the data into Oracle 9i.
In order to import when going down a version, use the lower version's export utility. So in your Oracle 9i database, create a TNS alias in your tnsnames.ora config file that points to your 10g database. Then invoke the 9i export utility and use the "@tns_alias" with your username to connect to the 10g database similar to the following:
exp userid=system@10g_database_alias 
file=my_dump.dmp full=y
Now that you have created a 9i dump file from the 10g database, you will be able to import into the 9i database without problems.

Dig Deeper on Oracle database export, import and migration

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close