I want to import a dump file but I have this error:

Import: Release - Production on Wed Feb 22 07:56:35 2023

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 19c Enterprise Edition Release - Production
ORA-39002: invalid operation
ORA-39166: Object HOSTTEST.OOD was not found or could not be exported or imported.

My command line:

impdp "'/ as sysdba'" directory=IMP dumpfile=SCHEMAS_FULL_27032020%U.DMP \
logfile=IMP_OOD_LOG.log tables=Hosttest.OOD remap_schema=Hosttest:Hosttest \

I confirm my schema exists:

enter image description here

What could be the problem?

  • 2
    The schema may exist, but is there the table HOSTTEST.OOD in the dump file? How did you check that?
    – mustaccio
    Feb 22 at 1:35
  • Please clarify your specific problem or provide additional details to highlight exactly what you need. As it's currently written, it's hard to tell exactly what you're asking.
    – Community Bot
    Feb 22 at 1:39


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Browse other questions tagged or ask your own question.