Source(Oracle ASM) to Target(Oracle ASM) – Import All Tablespaces into Single Tablespce

directory=DB_DIR1
REMAP_SCHEMA=RM:RMUAT
dumpfile=RMschema.dmp
logfile=import_RMUAT_node2.log
REMAP_TABLESPACE=IDX_NETVERTEX:RMUAT
REMAP_TABLESPACE=QM:RMUAT
REMAP_TABLESPACE=RM:RMUAT
REMAP_TABLESPACE=TBS_EDR_1:RMUAT
REMAP_TABLESPACE=TBS_EDR_12:RMUAT
REMAP_TABLESPACE=TBS_EDR_13:RMUAT
REMAP_TABLESPACE=TBS_EDR_14:RMUAT
REMAP_TABLESPACE=TBS_EDR_15:RMUAT
REMAP_TABLESPACE=TBS_EDR_2:RMUAT
REMAP_TABLESPACE=TBS_EDR_3:RMUAT
REMAP_TABLESPACE=TBS_EDR_4:RMUAT
REMAP_TABLESPACE=TBS_IDX_EDR:RMUAT
REMAP_TABLESPACE=TBS_IDX_NETVERTEXCUSTOMER01:RMUAT
REMAP_TABLESPACE=TBS_IDX_NETVERTEXCUSTOMER02:RMUAT
REMAP_TABLESPACE=TBS_IDX_NETVERTEXCUSTOMER03:RMUAT
REMAP_TABLESPACE=TBS_IDX_NETVERTEXCUSTOMER04:RMUAT
REMAP_TABLESPACE=TBS_IDX_NETVERTEXCUSTOMER05:RMUAT
REMAP_TABLESPACE=TBS_IDX_NETVERTEXCUSTOMER06:RMUAT
REMAP_TABLESPACE=TBS_IDX_NETVERTEXCUSTOMER07:RMUAT
REMAP_TABLESPACE=TBS_IDX_NETVERTEXCUSTOMER08:RMUAT
REMAP_TABLESPACE=TBS_NETVERTEXCUSTOMER01:RMUAT
REMAP_TABLESPACE=TBS_NETVERTEXCUSTOMER02:RMUAT
REMAP_TABLESPACE=TBS_NETVERTEXCUSTOMER03:RMUAT
REMAP_TABLESPACE=TBS_NETVERTEXCUSTOMER04:RMUAT
REMAP_TABLESPACE=TBS_NETVERTEXCUSTOMER05:RMUAT
REMAP_TABLESPACE=TBS_NETVERTEXCUSTOMER06:RMUAT
REMAP_TABLESPACE=TBS_NETVERTEXCUSTOMER07:RMUAT
REMAP_TABLESPACE=TBS_NETVERTEXCUSTOMER08:RMUAT
REMAP_TABLESPACE=TBS_SESS_USAGE_SMRY01:RMUAT
REMAP_TABLESPACE=TBS_SESS_USAGE_SMRY02:RMUAT
REMAP_TABLESPACE=TBS_SESS_USAGE_SMRY03:RMUAT
REMAP_TABLESPACE=TBS_SESS_USAGE_SMRY04:RMUAT
REMAP_TABLESPACE=TBS_SESS_USAGE_SMRY05:RMUAT
REMAP_TABLESPACE=TBS_SESS_USAGE_SMRY06:RMUAT
REMAP_TABLESPACE=TBS_SESS_USAGE_SMRY07:RMUAT
REMAP_TABLESPACE=TBS_SESS_USAGE_SMRY08:RMUAT
REMAP_TABLESPACE=TBS_TBLCORESESSION1:RMUAT
REMAP_TABLESPACE=TBS_TBLCORESESSION2:RMUAT
REMAP_TABLESPACE=TBS_TBLCORESESSION3:RMUAT
REMAP_TABLESPACE=TBS_TBLCORESESSION4:RMUAT
REMAP_TABLESPACE=TBS_TBLCORESESSION5:RMUAT
REMAP_TABLESPACE=TBS_TBLCORESESSION6:RMUAT
REMAP_TABLESPACE=TBS_TBLCORESESSION7:RMUAT
REMAP_TABLESPACE=TBS_TBLCORESESSION8:RMUAT
REMAP_TABLESPACE=TBS_TBLMADDONSUBSCRIBERREL1:RMUAT
REMAP_TABLESPACE=TBS_TBLMADDONSUBSCRIBERREL2:RMUAT
REMAP_TABLESPACE=TBS_TBLMADDONSUBSCRIBERREL3:RMUAT
REMAP_TABLESPACE=TBS_TBLMADDONSUBSCRIBERREL4:RMUAT
REMAP_TABLESPACE=TBS_TBLMADDONSUBSCRIBERREL5:RMUAT
REMAP_TABLESPACE=TBS_TBLMADDONSUBSCRIBERREL6:RMUAT
REMAP_TABLESPACE=TBS_TBLMADDONSUBSCRIBERREL7:RMUAT
REMAP_TABLESPACE=TBS_TBLMADDONSUBSCRIBERREL8:RMUAT
REMAP_TABLESPACE=TBS_TBLMDYNASPR01:RMUAT
REMAP_TABLESPACE=TBS_TBLMDYNASPR02:RMUAT
REMAP_TABLESPACE=TBS_TBLMDYNASPR03:RMUAT
REMAP_TABLESPACE=TBS_TBLMDYNASPR04:RMUAT
REMAP_TABLESPACE=TBS_TBLMDYNASPR05:RMUAT
REMAP_TABLESPACE=TBS_TBLMDYNASPR06:RMUAT
REMAP_TABLESPACE=TBS_TBLMDYNASPR07:RMUAT
REMAP_TABLESPACE=TBS_TBLMDYNASPR08:RMUAT
REMAP_TABLESPACE=TBS_TBLSESSIONRULE1:RMUAT
REMAP_TABLESPACE=TBS_TBLSESSIONRULE2:RMUAT
REMAP_TABLESPACE=TBS_TBLSESSIONRULE3:RMUAT
REMAP_TABLESPACE=TBS_TBLSESSIONRULE4:RMUAT
REMAP_TABLESPACE=TBS_TBLSESSIONRULE5:RMUAT
REMAP_TABLESPACE=TBS_TBLSESSIONRULE6:RMUAT
REMAP_TABLESPACE=TBS_TBLSESSIONRULE7:RMUAT
REMAP_TABLESPACE=TBS_TBLSESSIONRULE8:RMUAT
REMAP_TABLESPACE=TBS_USAGECDR_1:RMUAT
REMAP_TABLESPACE=TBS_USAGECDR_10:RMUAT
REMAP_TABLESPACE=TBS_USAGECDR_11:RMUAT
REMAP_TABLESPACE=TBS_USAGECDR_12:RMUAT
REMAP_TABLESPACE=TBS_USAGECDR_13:RMUAT
REMAP_TABLESPACE=TBS_USAGECDR_14:RMUAT
REMAP_TABLESPACE=TBS_USAGECDR_15:RMUAT
REMAP_TABLESPACE=TBS_USAGECDR_2:RMUAT
REMAP_TABLESPACE=TBS_USAGECDR_3:RMUAT
REMAP_TABLESPACE=TBS_USAGECDR_4:RMUAT
REMAP_TABLESPACE=TBS_USAGECDR_5:RMUAT
REMAP_TABLESPACE=TBS_USAGECDR_6:RMUAT
REMAP_TABLESPACE=TBS_USAGECDR_7:RMUAT
REMAP_TABLESPACE=TBS_USAGECDR_8:RMUAT
REMAP_TABLESPACE=TBS_USAGECDR_9:RMUAT

http://international-dba.blogspot.in/2014/05/impdp-remapdatafile-parameter.html
https://community.oracle.com/thread/498114?start=0&tstart=0

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s