1

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?

1
  • 4
    Sounds like you are trying to use data pump to import a dump that was created using the old exp tool. Mar 5, 2012 at 8:47

1 Answer 1

2

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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