As a DBA, We are using export/import utility many times during our daily process.
I have face this error trying to import only one table from full export.

Error message is

ORA-39002: invalid operation
ORA-39166: Object USER1.TABLE was not found.

My environment is:
OS: AIX 7.1
DB version : 11.2.0.4 – 2 Node RAC

My import syntax is:
impdp system/****@DB_NAME directory=DMP_DIR REMAP_SCHEMA=USER1:restore_user remap_tablespace=USER1_TS:Restorespace tables=USER1.TABLE dumpfile=MY_RAC_full.dmp logfile=imp.log cluster=n

So it gives:

ORA-39002: invalid operation
ORA-39166: Object USER1.TABLE was not found.

So I checked my full export log to can see USER1.TABLE has been exported or not. After checking log, I noticed table has been exported.

After making some search, I have been used below syntax to can fix issue:

impdp system/****@DB_NAME directory=DMP_DIR REMAP_SCHEMA=USER1:restore_user remap_tablespace=USER1_TS:Restorespace tables=”USER1″.”TABLE” dumpfile=MY_RAC_full.dmp logfile=imp.log cluster=n
Reklam