Data Pump - Parameter File

DIRECTORY             = Directory name from "CREATE DIRECTORY dpump_dir1 AS 'c:/data/datapump'"
CONTENT               = ALL, DATA_ONLY, METADATA_ONLY
DUMPFILE              = scott1.dmp, scott2.dmp (par_exp%u.dmp if parallel)
PARALLEL              = 1 (Max # of threads) (EE only) (chg on-the-fly) (have 1 file on separate disk for each)

FULL                  = Y|N (default = N)(must have EXP_FULL_DATABASE role)
SCHEMAS               = hr,scott,oe (default: login schema).
TABLESPACES           = tblsp1, tblsp2
TABLES                = emp, dept, salgrade, scott.table:partition
TRANSPORT_TABLESPACES = List of tablespaces from which metadata will be unloaded. (must have EXP_FULL_DATABASE role)
TRANSPORT_FULL_CHECK  = N - default. Verify storage segments of all tables

ESTIMATE              = BLOCKS - default or STATISTICS
ESTIMATE_ONLY         = N | Y

EXCLUDE               = Table[:EMP] , (Filter Metadata)
INCLUDE               = Table:Dept, (Filter Metadata) (Objects and their dependents)
INCLUDE               = TABLE:"IN ('EMPLOYEES', 'DEPARTMENTS')"
INCLUDE               = PROCEDURE
INCLUDE               = INDEX:"LIKE 'EMP%'"

SAMPLE                = .000001 - 99    SAMPLE="HR"."EMPLOYEES":50
QUERY                 = employees:'"WHERE department_id > 10 AND salary > 10000"'

FLASHBACK_SCN         = SCN used to set session snapshot back to.
FLASHBACK_TIME        = Time used to get the SCN closest to the specified time.

LOGFILE               = export.log
NOLOGFILE             = N

ATTACH                = Attach to existing job, e.g. ATTACH [= job name].
COMPRESSION           = METADATA_ONLY (default) or NONE
ENCRYPTION_PASSWORD   = Password key for creating encrypted column data.
FILESIZE              = Specify the size of each dumpfile in units of bytes.
JOB_NAME              = SYS_EXPORT__NN -- can't match any view or table in schema
NETWORK_LINK          = Name of remote database link to the source system.
STATUS                = 60 (every 60 secs job status is displayed. default=0
VERSION               = COMPATIBLE-default, LATEST, or any valid database version not less than 9.2