oracledba.help
Scripts

expDB.par

<- Scripts

# Usage: expdp system/Password PARFILE=expDB.par

COMPRESSION=ALL
DIRECTORY=exptmp
DUMPFILE=DB01.%U.DMP
FILESIZE=32g
FLASHBACK_TIME=systimestamp
FULL=Y
JOB_NAME=expDB
LOGFILE=xDatabase.log
PARALLEL=2
REUSE_DUMPFILES=YES


#QUERY=SCOTT.documents:"WHERE creationdate >= to_date('01-01-2014.0000.00','MM-DD-YYYY.HH24MI.SS') AND creationdate <= to_date('12-31-2014.2359.59','MM-DD-YYYY.HH24MI.SS')"
#QUERY=SCOTT.documentpages:"WHERE documentid IN (SELECT documentid FROM SCOTT.documents WHERE documents.creationdate >= to_date('01-01-2014.0000.00','MM-DD-YYYY.HH24MI.SS') AND creationdate <= to_date('12-31-2014.2359.59','MM-DD-YYYY.HH24MI.SS') )"

# OT Index Excludes
EXCLUDE=INDEX:"='DESCRIPTION_IDX'"

# SYSTEM: Excludes
EXCLUDE=SCHEMA:"='ANONYMOUS'"
EXCLUDE=SCHEMA:"='CTXSYS'"
EXCLUDE=SCHEMA:"='DBSNMP'"
EXCLUDE=SCHEMA:"='DIP'"
EXCLUDE=SCHEMA:"='DMSYS'"
EXCLUDE=SCHEMA:"='EXFSYS'"
EXCLUDE=SCHEMA:"='MGMNT_VIEW'"
EXCLUDE=SCHEMA:"='ORACLE_OCM'"
EXCLUDE=SCHEMA:"='ORDPLUGINS'"
EXCLUDE=SCHEMA:"='OUTLN'"
EXCLUDE=SCHEMA:"='TSMSYS'"
EXCLUDE=SCHEMA:"='SCOTT'"
EXCLUDE=SCHEMA:"='SYS'"
EXCLUDE=SCHEMA:"='SYSMAN'"
EXCLUDE=SCHEMA:"='SYSTEM'"
EXCLUDE=SCHEMA:"='WKSYS'"
EXCLUDE=SCHEMA:"='WMSYS'"

# User: Excludes
EXCLUDE=SCHEMA:"='RESTORE'"
EXCLUDE=SCHEMA:"='X15'"