ipdp from one schema to another in the same database
I am trying to import import one schema into another one. Here is my procedure1. expdp system schemas=SCHEMA1 directory=DATA_PUMP_DIR dumpfile=expdp_SCHEMA1.dmp logfile=expdp_SCHEMA1.log
2. impdp system directory=DATA_PUMP_DIR dumpfile=expdp_SCHEMA1.dmp logfile=impdp_SCHEMA1_to_SCHEMA2.log remap_schema=SCHEMA1:SCHEMA2 REMAP_TABLESPACE=TBLSP1:TBLSPC2 REMAP_TABLESPACE=SCHEMA1_TEMP:SCHEMA2_TEMP TABLE_EXISTS_ACTION=APPEND PARALLEL=5 TRANSFORM=oid:n
TABLE_EXISTS_ACTION=APPEND PARALLEL=5 TRANSFORM=oid:n, these directives don't do anything since the tables don't exist, and it doesn't hurt to have them there
If I do this procedure, where I export the schema from one database and import it into another database, works perfectly fine. I've done it, many, many times.
2. impdp system directory=DATA_PUMP_DIR dumpfile=expdp_SCHEMA1.dmp logfile=impdp_SCHEMA1_to_SCHEMA2.log remap_schema=SCHEMA1:SCHEMA2 REMAP_TABLESPACE=TBLSP1:TBLSPC2 REMAP_TABLESPACE=SCHEMA1_TEMP:SCHEMA2_TEMP TABLE_EXISTS_ACTION=APPEND PARALLEL=5 TRANSFORM=oid:n
TABLE_EXISTS_ACTION=APPEND PARALLEL=5 TRANSFORM=oid:n, these directives don't do anything since the tables don't exist, and it doesn't hurt to have them there
If I do this procedure, where I export the schema from one database and import it into another database, works perfectly fine. I've done it, many, many times.
1