Tuesday, 9 December 2014

remap_tablespace for mutliple tablespaces In Impdp

if you want to remap multiple table spaces while importing through data pump we need to use cama operator  as like below. 

remap_tablespace=Tablespace1:TablespaceA,Tablespace2:TablespaceB


Example:- 

impdp dumpfile=USER1.dmp logfile=USER1.log directory=EXPDP Full=y remap_tablespace=TEMP02:TEMP,USERDATA:USERS

No comments:

Post a Comment