Home > SQL Developer Dialog Boxes ... > Data Pump Export
This wizard is displayed if you expand a connection in the DBA navigator, right-click Export Jobs, and select Data Pump Export Wizard. (For information about using the DBA navigator, see Using DBA Features in SQL Developer.)
To use the Data Pump Export wizard, you must understand the concepts and techniques for Oracle Data Pump, as documented in Oracle Database Utilities.
Source page
Connection: Database connection to use to export the specified information for the specified types of objects.
Data or DDL: Specify whether to export only the data (applies to tables and views), only the object definitions (the "DDL)), or both the data and the object definitions.
Types to be Exported: Specify whether to export the database or just one or more tablespaces, schemas, or tables. (Your selection will affect the display of some remaining wizard pages.)
Tablespaces page
If you specified Tablespaces for Types to be Exported, select one or more tablespaces to be exported, and use the arrow icons to move them to the Selected Source Tablespaces box.
Schemas page
If you specified Schemas for Types to be Exported, select one or more schemas to be exported, and use the arrow icons to move them to the Selected Source Schemas box.
Tables page
If you specified Tables for Types to be Exported, select one or more tables to be exported, and use the arrow icons to move them to the Selected Source Schemas box.
Tables tab: To select one or more tables, see Specify Objects under Shared Wizard Pages.
Include/Exclude Filter tab: Optionally, filter the objects to be included or excluded, using the same interface as for the Filter page.
Filter page
Lets you specify data and metadata filtering to limit the type of information that is exported. You can specify multiple filters by adding rows.
If you specify any Include or Exclude rows, you must put any object names in single quotes. Example: Filter Type = TABLE
, and Expression = not in ('EMPLOYEES')
Table Data page
See Data under Shared Wizard Pages.
Options page
Lets you specify Data Pump Export options for the job.
Output Files page
Lets you specify one of more output (dump) files and certain options, including whether to delete existing dump files before creating new ones and whether to include the timestamp in dump file names.
Job Schedule page
Lets you specify scheduling options for the Data Pump Export job. The options include whether to start the job immediately or later, and any repeat options.
Summary page
See Summary under Shared Wizard Pages.
On the Summary page, you can click the PL/SQL tab to see the PL/SQL procedure that will perform the job. For information about the Data Pump PL/SQL API, see Oracle Database Utilities.