restore data pump

[Roshan]

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

[ErmanArslansOracleBlog]

the default value of that parameter is "SKIP" -- unless the CONTENT=DATA_ONLY is specified. If CONTENT= DATA_ONLY then the default is APPEND, not SKIP.

But in your case, it should be SKIP.

You are also doing some remap operations for that table.

There may be some contention due to that.. Please chek that. Check the logic of that. (Remember the cause : Cause: An object was already in existence that uses a name in common with this table. The name collision could be the table name, a constraint, a LOB storage table, or something else in the table definition.
Action: Drop the existing object before running Data Pump.)

Otherwise you got the following MOST Note to follow -> DataPump Table Import Fails with ORA-39325: TABLE_EXISTS_ACTION cannot be applied (Doc ID 2459545.1)