On the move:

I'm currently moving the following to their own blogs: Unix, HTML for Blogs, Perl & Java.
The links are on the left side.

Tuesday, September 2, 2008

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

No comments:

Post a Comment