Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have a file which I believed was an Oracle data dump, but Oracle refuses to import it:

There is a problem reading from the import files
ORA-39143
"C:\nm\data\THEFILE.dmp" may be an original export dump file

The Linux "file" utility says it is DBase 3, but I doubt this, because the records number is not realistic and DBase tools fail to load the file:

THEFILE.dmp: DBase 3 data file (1380929624 records)

Here is an hex dump of the beginning of the file:

0003 4501 5058 524f 3a54 3156 2e30 3230

Any idea what database format it could be?

share|improve this question
4  
Sounds like you are trying to use data pump to import a dump that was created using the old exp tool. –  a_horse_with_no_name Mar 5 '12 at 8:47
add comment

1 Answer

up vote 2 down vote accepted

As @a_horse_with_no_name says, it's a file created with the original export utility, i.e an exp command rather than expdp. You'll need to import it with the matching original import utility, using the imp command.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.