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

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


OS: AIX 7.1
DB version : 11.2.0.4 – 2 Node RAC
My syntax was:
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: ObjectUSER1.TABLE was not found.

While I checked my full export log, I saw that table has been exported.

After some search issue fix by using below syntax:
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

Advertisements