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

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.

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