Data Pump Export (ORCL10g ^)

From DBArtisan
Jump to: navigation, search

Go Up to Data, Schema, and Miscellaneous Utilities

The Data Pump Export utility lets you build and submit a call to the expdp.exe utility to unload a dump file specifically formatted to be loaded using the impdp.exe utility. The wizard lets you specify a full set of expdp.exe parameters, which are also saved to file for convenient reuse. When ready to import, you can execute from the wizard, or independently using a command line call to expdp.exe specifying the saved parameters file.

Before using this utility:

To create and execute a call to the Data Pump Export utility

  1. Connect to an Oracle datasource and ensure that it is the currently selected datasource. For details, see Connected/Selected Datasource options.
  2. Select Utilities > Data Pump Export to open the Data Pump Export Wizard.
  3. Use the following topics as a guide to setting properties and performing tasks as you pass through the wizard panels:

Finally, use the Finish button to perform the export.

Data Pump Export Wizard - Playback

When exporting a dump file set using the Data Pump Export Wizard, this panel offers the following options:

Required Information Description

New Data Pump Export

This initiates the process of creating a new export operation.

Use Existing Parameter File

If you want to replay an export operation, when you select the radio button, the browse function is enabled so you can find the .txt file you want to reuse.


Data Pump Export Wizard - Export Data Options

This wizard page lets you work with the following parameters:

Setting Group Description

Export Mode

Lets you select a mode, specifying the dump file set content type to be exported: Tables, Schemas, Full Dump File (corresponds to FULL parameter), or Tablespaces.

Options

Select a Data or DDL value of ALL, DATA ONLY, or METADATA only to provide a CONTENT= parameter value, specifying the data to unload. Select a Compression value of ALL, DATA ONLY, or METADATA only to provide a COMPRESSION= parameter value, indicating what to compress before writing to the dump file set.


Data Pump Export Wizard - Object Selection

If you selected an Export Mode of Tables, Schemas, or Tablespaces, select the check boxes corresponding to the specific database objects to be exported.

For more general information, such as how to open this Wizard, see Data Pump Import Wizard (ORCL10g ^).

Data Pump Export Wizard - Table Data Filter

This wizard page lets you include one or more QUERY= parameters, each specifying any valid QUERY= clause, such as a WHERE clause or ORDER BY clause. For each table that is to be filtered, click in the QUERY Clause field associated with the table and type a valid clause.

Note: Use the fields in the <ALL> row to filter the list.

For more general information, such as how to open this Wizard, see Data Pump Import Wizard (ORCL10g ^).

Data Pump Export Wizard - File and Job Settings

This wizard page lets you work with the following parameters:

Setting Group Description

Dump File

Directory - Select the directory object corresponding to the file system location where the dump file is to be stored. File name - Specify the full name of the dump file. Selecting Overwrite existing dump files adds a REUSE_DUMPFILES=Y parameter, ensuring that any existing dump files are overwritten. Selecting Existing files will prevent export adds a REUSE_DUMPFILES=N parameter.

Enable Logging

If Enable Logging is unselected, a NOLOGFILE=Y parameter is included with the utility call. To enable logging, select Enable Logging and if required, overwrite the default Log File name. This includes a LOGFILE= parameter with the utility call.

Job

Lets you provide a JOBNAME= parameter value that will be included with the utility call.

For more general information, such as how to open this Wizard, see Data Pump Import Wizard (ORCL10g ^).

Data Pump Export Wizard - Advanced Parameters

The Data Pump Import Wizard builds and submits a call to the expdp.exe utility, specifying a minimal, required set of parameters, specified on preceding pages of the wizard. The Advanced Parameters page lets you provide any additional parameter=value pairs supported by the utility.

Note: For a listing of additional, supported parameters, see Data Pump Import/Export Parameters that can be Added Manually.
  • Use the New button to open the Add Data Pump Parameter dialog. Select a parameter name from the Name dropdown and in the Value box, provide the associated value.
  • Use the Edit and Delete buttons to modify or remove selected parameters.


Data Pump Export Wizard - Summary

This wizard page provides a summary of the expdp.exe parameters you chose on previous pages of the wizard. It also displays:

  • The location of the generated parameters file (.txt).
  • Instructions on how to execute the export independently of the wizard, using the parameters file

For more general information, such as how to open this Wizard, see Data Pump Import Wizard (ORCL10g ^).