How to Import Dump with 2 Schemas for Different Dataspaces

Asked

Viewed 97 times

0

I have a Dump with which it was made expdp with 2 schemas. I’d like to do the impdp remapping the tablespace for 2 new tablespaces.

Man 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

database oracle oracle11g dump

1 answer

0


As I wanted it is not possible, but to solve the problem, I must do it in parfiles separate, defining which schema I want to import, ie:

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

Browser other questions tagged database oracle oracle11g dump

You are not signed in. Login or sign up in order to post.