Error in importing dmp file in SQL Developer cannot be resolved

Asked 2 years ago, Updated 2 years ago, 58 views

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

Enter a description of the image here

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:

  • windows10
  • oracle12c(R2)
  • oracle SQL Developer

sql oracle

2022-09-29 22:07

1 Answers

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:

  • Export by expdp.exe in the source database.
  • Run imp.exe to import the new database.
    • You must review SQL Developer options or run imp.exe directly from the command line
    • 11g or later, exp.exe/imp.exe is deprecated, so it is not clear if it can be applied to 18c or later (unconfirmed)
  • You must review SQL Developer options or run imp.exe directly from the command line
  • 11g or later, exp.exe/imp.exe is deprecated, so it is not clear if it can be applied to 18c or later (unconfirmed)

cf:How to use Export/Import


2022-09-29 22:07

If you have any answers or tips


© 2024 OneMinuteCode. All rights reserved.