Database Utilities (MOSC)

MOSC Banner

impdp table data to another table, in Oracle 11.1.0.7?

edited Apr 8, 2013 12:40PM in Database Utilities (MOSC) 6 commentsAnswered
Dear Oracle,

I have a dmp file by expdp schema=mySchema

I need import a table data from the dmp file into another table, ignore all constrains, in same schema.

I do NOT change data in my original table.

Please help me.

I used,

impdp mpss/mpss DIRECTORY=data_pump_dir DUMPFILE=mydmp.dmp TABLES=mySchema.User_roles_service REMAP_TABLE=mySchema.User_roles_service:anotherTable

I got,

ORA-39151: Table "mySchema"."USER_ROLES_SERVICE" exists. All dependent metadata and data will be skipped due to table_exists_action of skip 

if I added,  TABLE_EXISTS_ACTION=truncate

Still no data in my anothertable and also data in User_roles_service was changed.

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