Database Utilities (MOSC)

MOSC Banner

Cloning a schema using Datapump

edited Sep 21, 2011 9:00AM in Database Utilities (MOSC) 2 commentsAnswered ✓
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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center