ora-01110 while importing


$ imp user/password file=/datadump/BILL_REGISTER_AP.dmp full=Y log =/datadump/cdma01092010.log

 

Import: Release 9.2.0.6.0 - Production on Wed Sep 1 14:37:21 2010

 

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

 
Connected to: Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production

With the Partitioning, OLAP and Oracle Data Mining options

JServer Release 9.2.0.6.0 - Production

 

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

IMP-00000: Import terminated unsuccessfully

 

Solution

 
Either  oracle version mismatch between databases

Or

Export dump file is corrupt.

If done ftp  of the dumpfile to the server it should be with binary mode   --

Post a Comment

And that's all there is to it!

If anyone has any other questions or requests for future How To posts, you can either ask them in the comments or email me. Please don't feel shy at all!

I'm certainly not an expert, but I'll try my hardest to explain what I do know and research what I don't know.

Previous Post Next Post