Home » RDBMS Server » Server Utilities » Import a 10g dmp file from 9i (unix)
Import a 10g dmp file from 9i [message #397688] Mon, 13 April 2009 06:49 Go to next message
alzuma
Messages: 46
Registered: July 2006
Location: CA
Member
Dears,

how can in 9i, import file taken by 10g export.
since it give me this error:

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

Thanks
Re: Import a 10g dmp file from 9i [message #397690 is a reply to message #397688] Mon, 13 April 2009 06:55 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


>>: Import a 10g dmp file from 9i

??

I can't understand; You trying to import 10g dumpfile to 9i Or ??

Babu
Re: Import a 10g dmp file from 9i [message #397691 is a reply to message #397688] Mon, 13 April 2009 06:56 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
The recommended way is to use the lower version of exp to export and same lower version to import.
>>how can in 9i, import file taken by 10g export.
You have to prove that.
May be the file is corrupted. Did you ftp it ?
Are you sure the file was created by Exp and not expdp?
Re: Import a 10g dmp file from 9i [message #397698 is a reply to message #397691] Mon, 13 April 2009 07:18 Go to previous messageGo to next message
alzuma
Messages: 46
Registered: July 2006
Location: CA
Member
Dear,

- yes, i want import a 10g dump file to 9i DB
- the file transfered by ftp successfly
- i use the old exp not expdb

Thanks
Re: Import a 10g dmp file from 9i [message #397705 is a reply to message #397698] Mon, 13 April 2009 07:46 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do you use 9i exp?
This is the condition sine qua non.

Regards
Michel
Re: Import a 10g dmp file from 9i [message #397816 is a reply to message #397705] Tue, 14 April 2009 01:07 Go to previous message
alzuma
Messages: 46
Registered: July 2006
Location: CA
Member
Thanks alot Michel

i re-genetate the 10g dump file by using the 9i exp
then import it by the 9i imp utility also
it is fine .

Thanks
Previous Topic: impdp error
Next Topic: Export Full DB with no Tablespace
Goto Forum:
  


Current Time: Wed Dec 07 20:14:49 CST 2016

Total time taken to generate the page: 0.13999 seconds