Data Pump Export (ORCL10g ^)
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:
- You must specify the location of the expdp.exe utility. For more information, see Oracle Utilities Options.
- Consult Oracle documentation for detailed information on use of the expdp.exe utility. For more information, see Accessing Third Party Documentation.
- You should also familiarize yourself with support for the Oracle Data Pump Import Utility. For details, see Data Pump Import Wizard (ORCL10g ^).
To create and execute a call to the Data Pump Export utility
- Connect to an Oracle datasource and ensure that it is the currently selected datasource. For details, see Connected/Selected Datasource options.
- Select Utilities > Data Pump Export to open the Data Pump Export Wizard.
- Use the following topics as a guide to setting properties and performing tasks as you pass through the wizard panels:
- Data Pump Export Wizard - Playback.
- Data Pump Export Wizard - Export Data Options.
- Data Pump Export Wizard - Object Selection.
- Data Pump Export Wizard - Table Data Filter.
- Data Pump Export Wizard - File and Job Settings.
- Data Pump Export Wizard - Advanced Parameters.
- Data Pump Export Wizard - Summary.
Finally, use the Finish button to perform the export.
Contents
- 1 Data Pump Export Wizard - Playback
- 2 Data Pump Export Wizard - Export Data Options
- 3 Data Pump Export Wizard - Object Selection
- 4 Data Pump Export Wizard - Table Data Filter
- 5 Data Pump Export Wizard - File and Job Settings
- 6 Data Pump Export Wizard - Advanced Parameters
- 7 Data Pump Export Wizard - Summary
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 ^).