Cloning a schema using Datapump
Hello all,
I would like to clone an existing schema, tablespace and datafiles from source_schema to new_source_schema. Here is the proposed syntax:
impdp system DIRECTORY=data_pump_dir DUMPFILE=source_schema.dmp LOGFILE=source_schema.imp REMAP_SCHEMA=
source_schema:NEW_source_schema REMAP_DATAFILE=\'C:\APP\ORADATA\ORCL\source_schema_TBL01.DBF\':\'C:\A
PP\ORADATA\ORCL\NEWsource_schema_TBL01.DBF\',\'C:\APP\ORADATA\ORCL\source_schema_IDX01.DBF\':\'C:\APP\ORADATA\ORCL\NEWsource_schema
_IDX01.DBF\' remap_tablespace=source_schema_tbl:newsource_schema_tbl remap_tablespace=source_schema_idx:newsource_schema_idx
I would like to clone an existing schema, tablespace and datafiles from source_schema to new_source_schema. Here is the proposed syntax:
impdp system DIRECTORY=data_pump_dir DUMPFILE=source_schema.dmp LOGFILE=source_schema.imp REMAP_SCHEMA=
source_schema:NEW_source_schema REMAP_DATAFILE=\'C:\APP\ORADATA\ORCL\source_schema_TBL01.DBF\':\'C:\A
PP\ORADATA\ORCL\NEWsource_schema_TBL01.DBF\',\'C:\APP\ORADATA\ORCL\source_schema_IDX01.DBF\':\'C:\APP\ORADATA\ORCL\NEWsource_schema
_IDX01.DBF\' remap_tablespace=source_schema_tbl:newsource_schema_tbl remap_tablespace=source_schema_idx:newsource_schema_idx
0