I want to import dmp files exported from a different database into my database, but I get the following error when importing dmp files in SQL Developer:
error messages:
Exception: ORA-39001: Invalid argument
dbms_datapump.get_status
ORA-39001—Invalid argument
ORA-39000: Invalid dump file specification
ORA-39143: The dump file "C:\temp\M01.dmp" may be the original export dump file
After searching, I found that there are the following cases:
Invalid ORA-39000 dump file specification
Cause: A dump file was specified that is not available for the current job.Subsequent error messages contain incorrect dump files.
Action: Specify a dump file that can be used for the job.
Invalid ORA-39001 argument
Cause: You specified API parameters with incorrect type or range of values.Subsequent messages displayed by DBMS_DATAPUMP.GET_STATUS contain errors.
Action: Correct invalid arguments and retry the API.
The ORA-39143 dump file "string" may be the original export dump file
Cause: The import operation specified a dump file that may have been created using the original export utility.These dump files cannot be processed by the Data Pump Import Utility.
Action: Use the original import utility to process this dump file.
Perhaps the dmp file is the cause of the error, but I don't understand the meaning of "Please use the original import utility to handle this dump file."
I searched various ways, but I couldn't find any countermeasures, so I asked you a question.
Thank you for your cooperation.
running environment:
The data output in exp.exe
is loaded in impdp.exe
, which may be causing the error in your question.
SQL Developer import/export should be calling one of the above tools on the back, but the tools are divided into several types.
cf: BSQL* Loader, Export and Import Instant Client Table B-1 Tool Package Instant Client
Data output from the old database in exp.exe
(classic export tool) cannot be read in impdp.exe
(new import tool recommended after 11g).
One of the following actions may help avoid errors:
expdp.exe
in the source database.imp.exe
to import the new database.
imp.exe
directly from the command lineexp.exe
/imp.exe
is deprecated, so it is not clear if it can be applied to 18c or later (unconfirmed)imp.exe
directly from the command lineexp.exe
/imp.exe
is deprecated, so it is not clear if it can be applied to 18c or later (unconfirmed)
© 2024 OneMinuteCode. All rights reserved.