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
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