First page Back Continue Last page Graphics

Continuation of Notes


Notes:

Notes continued from the previous page:
SCHEMAS – This is the export mode. It is analogous to OWNER= parameter available with original export. Other supported modes are FULL, TABLE, TABLESPACE and TRANSPORATBLE TABLESPACE.
PARALLEL – Specify the maximum degree of parallelism (DOP). Note that this is not necessarily the maximum number of processes spawned for the job. For example, datapump will create a master control process to coordinate the worker processes; the master process is not included in the DOP number specified. Be sure to have at least as many dump files as the DOP setting. Failing to do so can decrease performance or cause ORA-39095 error. Refer to the Oracle10g Utilities manual, Chapter 2, PARALLEL parameter for more information.
DIRECTORY – Specify the default directory for dump, log and SQLFILES.
DUMPFILE – Specify the “dump file set”, i.e. one or more OS files that will contain the output of the export operation. Be sure to have at least as many dump files as the DOP setting. The %U generates a sequential number starting at 1, which is required if datapump creates additional files in the dump set. This will occur if the dump file size limit is reached (if the FILESIZE parameter is coded), or “to keep parallel workers active.” Refer to the Oracle10g Utilities manual, Chapter 2, DUMPFILE parameter for more information. Note that datapump will not overwrite an existing dump file – an error is returned and the job terminates.
LOGFILE – Specify the name of the log file. The log file can be written to a different directory with the following syntax:
LOGFILE= directory_name:logfile_name
Datapump will overwrite existing log files without warning.