Monday, 4 March 2019

IMPDP import remap_schema and remap_tablespace | import into multiple tablespaces | DATAPUMP

impdp username/****** directory=<directory_name> dumpfile=<DUMPFILE> logfile=<logtobeexported.log> remap_schema=<data_from_username:to_username> 
remap_tablespace=<FROMTBS01:totbs>
remap_tablespace=<FROMTBS02totbs> 
remap_tablespace=<FROMTBS03:totbs> 
remap_tablespace=<FROMTBS04:totbs01>


EXAMPLE:

impdp DBATASK2/****** directory=DATA_PUMP_DIR dumpfile=toblr_201903051207.dmp logfile=toblr_imp.log remap_schema=toblr:meshoodb remap_tablespace=PROD_FS_APP_01:TEST_DATA remap_tablespace=PROD_FS_INDX_01:TEST_DATA remap_tablespace=PROD_FS_APP_LOB01:TEST_DATA remap_tablespace=PROD_FS_INDX_LOB01:TEST_DATA
remap_tablespace=PROD_FS_APP_MSTR:TEST_DATA_01

1 comment:

  1. Vasista24 July 2020 at 07:55

    Hi .. I am getting Error due to remap_tablespace .. it is not taking source db table space in targer db. I am using 11.2.0.2 db export .. dmp file . importing in 12.2.0.1 db. do you have any idea? pls share your comments

    ReplyDelete

Subscribe to: Post Comments (Atom)