impdp error ORA-39151: Table "schema"."table" exists. All dependent metadata and data will be skippe
Hi,
I have a table tA in schema sA. Can I import it into schema sB with a new table name? I have the exported expdp dump file.
When I issue:
impdp sys/pwd tables=sA.tA directory=dp_dir dumpfile=xxx.dmp remap_table=sA.tA:sB.tA_new
I got this error:
ORA-39151: Table "sA"."tA" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
Seems like the remap_table not working to me. Of course sA.tA exists, which is the one I don't want to touch, that's why I'm importing it to a different schema so that I can work there. Oracle 11.1.0.7