Home » RDBMS Server » Server Utilities » IMP-00010
IMP-00010 [message #268901] Thu, 20 September 2007 01:24 Go to next message
risy_s
Messages: 44
Registered: September 2005
Location: Mumbai
Member

hi

i m importing 10g database dump to 9i database

i have made an entry in tnsnames. ora file in oracle 9i home for the 10g database

then i have log in 9i home and took export of 10g db like this

exp system/password@dbname owner=username file=filename log=logname

after that i have set oracle sid for the 9i db into which i need to import the dump
like this i did import

imp system/password file=file log=log fromuser=username touser=usename

but it is giving me errror while importing data below is the error
IMP-00010: not a valid export file, header failed verification
IMP-00000: Import terminated unsuccessfully

what is wront in this..... ?
Re: IMP-00010 [message #268903 is a reply to message #268901] Thu, 20 September 2007 01:29 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

IMP-00010: not a valid export file, header failed verification
Export File is corrupted you have to re-export dump files.


Regards
Mohammed Taj
Re: IMP-00010 [message #268906 is a reply to message #268901] Thu, 20 September 2007 01:38 Go to previous messageGo to next message
risy_s
Messages: 44
Registered: September 2005
Location: Mumbai
Member

it is not like that... problem bcoz of imp/exp betn diff version

Re: IMP-00010 [message #268911 is a reply to message #268906] Thu, 20 September 2007 01:48 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please read and follow OraFAQ Forum Guide, especially section about IM speak.

Regards
Michel
Re: IMP-00010 [message #268918 is a reply to message #268906] Thu, 20 September 2007 02:01 Go to previous messageGo to next message
risy_s
Messages: 44
Registered: September 2005
Location: Mumbai
Member

Thanks

Problem has been resolved
Re: IMP-00010 [message #268924 is a reply to message #268906] Thu, 20 September 2007 02:13 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

IMP-00010: not a valid export file, header failed verification

Cause: Either the file was not generated by Export or it was corrupted.

Action: If the file was indeed generated by Export, report this an Import bug and submit the export file to customer support.

and if version problem then you have to use ORACLE 10G CLIENT to import ORACLE 10G EXPORTED DUMP files.


Regards
Mohammed Taj
Re: IMP-00010 [message #269065 is a reply to message #268918] Thu, 20 September 2007 11:01 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
risy_s wrote on Thu, 20 September 2007 01:01
Thanks

Problem has been resolved



Post your solution.
Previous Topic: Loading data in remote machine using sqlldr command
Next Topic: Importing table in different database
Goto Forum:
  


Current Time: Sat Dec 03 09:51:30 CST 2016

Total time taken to generate the page: 0.11761 seconds