Data Pump Import

This wizard is displayed if you expand a connection in the DBA navigator, right-click Import Jobs, and select Data Pump Import Wizard. (For information about using the DBA navigator, see Using DBA Features in SQL Developer.)

To use the Data Pump Import wizard, you must understand the concepts and techniques for Oracle Data Pump, as documented in Oracle Database Utilities.

Type page

Connection: Database connection to use to import the specified information for the specified types of objects.

Job Name: Name to be given to this import job.

Data or DDL: Specify whether to import 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 Imported: Specify whether to import the database from the dump file or files, or just one or more tablespaces, schemas, or tables. (Your selection will affect the display of some remaining wizard pages.)

Choose Import Files: Specify one or more dump files (that were created using Data Pump Export) from which to import the objects. To add files, click Add Row.

Tablespaces page

If you specified Tablespaces for Types to be Imported, select one or more tablespaces to be imported, and use the arrow icons to move them to the Selected Source Tablespaces box.

Schemas page

If you specified Schemas for Types to be Imported, select one or more schemas to be imported, and use the arrow icons to move them to the Selected Source Schemas box.

Tables page

If you specified Tables for Types to be Imported, select one or more tables to be imported, 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 imported. You can specify multiple filters by adding rows.

Table Data page

See Data under Shared Wizard Pages.

Ramapping page

Lets you specify options for the relevant Data Pump Import "remapping" parameters (REMAP_DATAFILE, REMAP_SCHEMA, REMAP_TABLESPACE).

Options page

Lets you specify Data Pump Import options for the job.

Job Schedule page

Lets you specify scheduling options for the Data Pump Import 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.