How to import Dump with 2 schemas for different dataspaces

0

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

    
asked by anonymous 15.07.2016 / 14:18

1 answer

0

As I wanted it is not possible, but to solve the problem, I should do this in parfiles separated, defining which schema I want to import, that is:

impdp-ryu.par

userid=dba/dba@streetfight
dumpfile=expdp-ryueken-15072016.dmp
logfile=impdp-ryueken-15072016_imp.log

REMAP_SCHEMA=SCHEMA_RYU:RYU
REMAP_TABLESPACE=TEMP:RYU_TABLESPACE

SCHEMA=SCHEMA_RYU

TRANSFORM=OID:n:type

impdp-ken.par

userid=dba/dba@streetfight
dumpfile=expdp-ryueken-15072016.dmp
logfile=impdp-ryueken-15072016_imp.log

REMAP_SCHEMA=SCHEMA_KEN:KEN
REMAP_TABLESPACE=TEMP:KEN_TABLESPACE

SCHEMA=SCHEMA_KEN

TRANSFORM=OID:n:type
    
17.08.2016 / 17:07