Oracle 12c IMPDP errors

Question

The import command...

impdp user/password DIRECTORY=desktop_import DUMPFILE=SENIORS4_Feb1.dmp TABLES=(DOCUMENT_PUBLISH, MEDIA_APPLICANT) REMAP_TABLESPACE=SENIORDB:import_user REMAP_SCHEMA=SENIORDB:import_user

...causes these errors:

Connected to: Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production

ORA-39002: invalid operation

ORA-39166: Object IMPORT_USER.MEDIA_APPLICANT was not found or could not be exported or imported.

ORA-39166: Object IMPORT_USER.DOCUMENT_PUBLISH was not found or could not be exported or imported.

When I searched the web, most of these errors were associated with problems creating log files.

Littlefoot · Accepted Answer · 2018-05-15 20:53:55Z

1

Try to precede table names with their owner name, i.e.

TABLES=(SENIORDB.DOCUMENT_PUBLISH, SENIORDB.MEDIA_APPLICANT)

or even by enclosing both of them into double quotes, such as

TABLES=("SENIORDB"."DOCUMENT_PUBLISH", "SENIORDB"."MEDIA_APPLICANT")

answered May 15, 2018 at 20:53

Littlefoot

144k15 gold badges41 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Oracle 12c IMPDP errors

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related