Wednesday 13 February 2013

Using remap_schema in datapump

Table export using,


C:\ expdp system\acomplexepassword@tnsname directory=data_pump_dir dumpfile=Mydump%U.dmp tables=my,big,list,of,tables


And here you go. Your data are exported.
Then use the impdp command as follow:

If you are importing the data from one schema to another schema and another tablespace ,you have to use the below query to get it done.,


C:\ impdp system\acomplexepassword@tnsname directory=data_pump_dir dumpfile=mydump01.dmp remap_schema=source_schema:dest_schema remap_tablespace=source_tablespace:dest_tablespace