oracledba.help

expSchema.par

<- Scripts

# expdp system/Password PARFILE=expSchema.par

COMPRESSION=ALL
DIRECTORY=exptmp
FLASHBACK_TIME=systimestamp
JOB_NAME=expSchema
REUSE_DUMPFILES=YES
EXCLUDE=INDEX:"='DESCRIPTION_IDX'"
EXCLUDE=STATISTICS

#DUMPFILE=Schema.dmp
LOGFILE=Schema.scott.log
SCHEMAS=scott

#QUERY=SCOTT.documents:"WHERE creationdate >= to_date('01-01-2016.0000.00','MM-DD-YYYY.HH24MI.SS') AND creationdate <= to_date('12-31-2016.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-2016.0000.00','MM-DD-YYYY.HH24MI.SS') AND creationdate <= to_date('01-31-2016.2359.59','MM-DD-YYYY.HH24MI.SS') )"

DUMPFILE=scott.%U.dmp
FILESIZE=32g
PARALLEL=2