Database Administration (MOSC)

MOSC Banner

impdp error ORA-39151: Table "schema"."table" exists. All dependent metadata and data will be skippe

edited Oct 30, 2015 1:52PM in Database Administration (MOSC) 6 commentsAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center