restore data pump

Posted by Roshan on Sep 27, 2023; 10:48am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/restore-data-pump-tp12076.html

Oracle 19c

Hello Erman,

I am getting error below

[oracle@T24R18DBDEV FUND]$ impdp  \"/ as sysdba\" logfile=import20190201_20190731.log remap_schema=T24PROD:FUNDARC remap_table=T24PROD.'FBNK_TELLER#ARC':'FBNK_TELLER#ARC20190201_20190731' remap_tablespace=T24PRODINDEX:T24PRODINDEX20190201_20190731,T24PRODLOB:T24PRODLOBF20190201_20190731,T24PRODDATA:T24PRODDATAF20190201_20190731 directory=fumimport full=y dumpfile=teller_20190201_20190731.expdp.dmp

when restoring dump

Processing object type TABLE_EXPORT/TABLE/TABLE
ORA-39325: TABLE_EXISTS_ACTION cannot be applied to "FUNDARC"."FBNK_TELLER#ARC20190201_20190731".

Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT

I checked for any duplicate objects under schema FUNDARC  but none found.

Kindly advise.

Thanks,
Roshan