Imp problem...

[elziko]

... I have been given an exported .DMP file from a client. I need to import it into our database however after running the 'imp' command I get the following error message after choosing the default buffer size:

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

I have checked teh .DMP file against one created on our systems using the 'exp' command and the only immediate difference I have noticed is that our Export version is "EXPORT:V08.01.05" and their version is "EXPORT:V08.01.06F".

Any ideas on what I should try?

Cheers

ellziko

 

[THoey]

Are you sure that the version of Oracle that you are using is the same as the version that they are using, right down to the patch levels? "Alcohol is our friend, and it's about time we had more friends over."

Terry M. Hoey

 

[jgaines1]

Oracle imp is upwards compatible, but not downward compatible. One solution that I have used before is to run the exp command on your 8.1.5 instance to extract the data from the 8.1.6 database, just add an entry to your tnsnames.ora file and connect remotley. If this is not an option you could ouput the data to a flat file and use SQL Loader.

Good Luck.

 

[elziko]

Thanks for the help, I think were just gonna upgrade to 8.1.7. Which took a while to sort out on the phone to Oracle.... their database was down. Oh.