I have a Dump with which expdp
was made with 2 schemas.
I would like to impdp
remap tablespace
to 2 new
tablespaces
.
My parfile
current:
userid=dba/dba@streetfight
dumpfile=expdp-ryueken-15072016.dmp
logfile=impdp-ryueken-15072016_imp.log
#sqlfile=impdp-ryueken-15072016_imp.sql
REMAP_SCHEMA=SCHEMA_RYU:RYU
REMAP_SCHEMA=SCHEMA_KEN:KEN
REMAP_TABLESPACE=TEMP:STREET
TRANSFORM=OID:n:type
But I wanted something like this:
userid=dba/dba@streetfight
dumpfile=expdp-ryueken-15072016.dmp
logfile=impdp-ryueken-15072016_imp.log
#sqlfile=impdp-ryueken-15072016_imp.sql
REMAP_SCHEMA=SCHEMA_RYU:RYU
REMAP_SCHEMA=SCHEMA_KEN:KEN
REMAP_TABLESPACE=TEMP:RYU_TABLESPACE
REMAP_TABLESPACE=TEMP:KEN_TABLESPACE
TRANSFORM=OID:n:type
Thank you