Optimized Database Import
Overview
Though full database imports are supposed to exclude much of the schema listed here, you may find this provides for a cleaner import. Plus Oracle feels it cannot hurt!
################################################################################# # Purpose: Parameter file to import database from a Data Pump dump file. # Usage: impdp system PARFILE=importDatabase.par # Comments: Directory Object must exist before running. ################################################################################# DIRECTORY=datapump DUMPFILE=FULL_01.DMP,FULL_02.DMP FULL=Y JOB_NAME=ImportDatabase LOGFILE=importDatabase.log EXCLUDE=SCHEMA:"='ANONYMOUS'" EXCLUDE=SCHEMA:"='CTXSYS'" EXCLUDE=SCHEMA:"='DBSNMP'" EXCLUDE=SCHEMA:"='DIP'" EXCLUDE=SCHEMA:"='DMSYS'" EXCLUDE=SCHEMA:"='EXFSYS'" EXCLUDE=SCHEMA:"='IMD'" EXCLUDE=SCHEMA:"='MGMNT_VIEW'" EXCLUDE=SCHEMA:"='ORACLE_OCM'" EXCLUDE=SCHEMA:"='ORDPLUGINS'" EXCLUDE=SCHEMA:"='OUTLN'" EXCLUDE=SCHEMA:"='RESTORE'" EXCLUDE=SCHEMA:"='SCOTT'" EXCLUDE=SCHEMA:"='SITESCOPE'" EXCLUDE=SCHEMA:"='SYS'" EXCLUDE=SCHEMA:"='SYSTEM'" EXCLUDE=SCHEMA:"='SYSMAN'" EXCLUDE=SCHEMA:"='TSMSYS'" EXCLUDE=SCHEMA:"='WKSYS'" EXCLUDE=SCHEMA:"='WMSYS'" # Custom Excludes EXCLUDE=SCHEMA:"='X15'" # Enterprise Edition Option PARALLEL=2