impdp table data to another table, in Oracle 11.1.0.7?
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.