Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Import data from exp file

pacossOct 10 2006 — edited Oct 10 2006
hi,

i've just faced to a problem about importing data from export file. well, i've got a file named tis_dem.exp from a client located in a different town and have to import data from that file into the db i've just created. file contains the whole database, and i tried to perform import using oem ('import from export files'), but i got an error:

There is a problem reading from the import files: ORA-39143: dump file "D:\dean_oracledb_data\st_test\Exp\TIS_DEM.exp" may be an original export dump file .

so, i googled to find this error and found the following:

ORA-39143:
Cause: A dump file was specified for an import operation which appears to have been created using the original export utility. These dump files cannot be processed by the Data Pump import utility.
Action: Try using the original import utility to process this dump file.

so, my question is where to find the original import utility and how to do it with it?

thanks in advance
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 7 2006
Added on Oct 10 2006
8 comments
384 views