First page Back Continue Last page Graphics

Export Example…

Notes:

This example demonstrates a simple schema-mode export operation, using parallel processing. Steps include:
Creating a directory if one is not already available. The directory is used by datapump operations as the location for dump files, log files and SQLFILES (optionally created by datapump import to show the DDL in the dump file – like the SHOW parameter with original import). Different directories can be used. For example, to write the log file in a separate directory, code LOGFILE=directory:filename.
Creating a parameter file. This example uses the following parameters:
JOB_NAME – Optional parameter. The job name is used when monitoring the job (see DBA_DATAPUMP_JOBS) and reattaching to the job (see the ATTACH parameter on the expdp and impdp commands.) The JOB_NAME parameter is also important because datapump creates a table in your schema that helps control the datapump process. This table is dropped when the job completes successfully. Be sure to choose a name that does not conflict with an existing table name in your schema.

Notes for this slide continue on the next page…