Home » RDBMS Server » Server Utilities » import d.dmp file (oracle 11g , os windows xp)
import d.dmp file [message #552992] Mon, 30 April 2012 13:29 Go to next message
miroconnect@yahoo.com
Messages: 202
Registered: April 2006
Senior Member
I am trying to import .dmp file to my databse

I am trying to run the imp command from dos prompt.
Here is the error I got .


C:\Documents and Settings\sairamm\My Documents\artms\exp_AUDT2_04292012>imp  
sairamm/mypassword@aws fromuser=AUDT2 toUSER=SAIRAMM file=exp_AUDT2_04292012.dmp 
log=imp_AUDT2_04292012.log BUFFE
R=10000000 GRANTS=y

Import: Release 9.2.0.1.0 - Production on Mon Apr 30 14:23:29 2012

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing option

IMP-00010: not a valid export file, header failed verification
IMP-00000: Import terminated unsuccessfully


please advice me what is wrong ?

[Updated on: Mon, 30 April 2012 13:38] by Moderator

Report message to a moderator

Re: import d.dmp file [message #552993 is a reply to message #552992] Mon, 30 April 2012 13:34 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
the two common causes of this are
1) file was not copied in "binary" mode between systems.
2) export was done by a version of Oracle that is newer/higher than the current "imp" utility.
Re: import d.dmp file [message #552994 is a reply to message #552992] Mon, 30 April 2012 13:39 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Import: Release 9.2.0.1.0

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0


Import 9.2 does not understand export from 11.2.
Check your versions.
Better use a 11.2 client.

Regards
Michel
Previous Topic: monitoring export ,import job and tuning
Next Topic: impdp ORA-39029
Goto Forum:
  


Current Time: Fri Mar 29 06:15:56 CDT 2024