12.1 Importing Data
This section provides the steps for importing data using Oracle Data Pump into your on-premises database.
Note:
Before you begin, you must have an export job. To create an export job using cURL, see Create an Export Data Pump Job in REST APIs for Oracle Database.
- In the Data Pump page, on the top right, click
Import.
The Import wizard appears.
- In the Source step, enter the following fields:
- Directory: Select the directory that contains the source dump files.
- Import Pattern: Type the import pattern.
Click Next.
- In the Import step, enter the following fields:
- Import Name: Enter a name for the import job.
- Import Type: Select the type of
import. The options are Full, Tables, Schemas, and Tablespaces.
Note:
If you select Full, you skip the Filter step in the wizard and directly go to the Mapping step. - Content: Select Data Only, DDL Only, or Data and DDL.
- Encrypt: Select if encrypted and enter an encryption password.
Click Next.
- In the Filter step, depending on the import type, all the schemas, tables, or tablespaces for the import job are listed. Select the ones that apply. Click Next.
- In the Mapping step, select the source schema and enter a new name for the target schema. If needed, do the same for tablespaces. Click Next.
- In the Options step, enter the following fields:
- Threads: Specifiy the maximum number of threads of active execution operating on behalf of the import job. The default is 1.
- Action on Table if Table Exists: Specify the action needed if that table that import is trying to create already exists.
- Skip Unusable indexes: Select to specify whether the import skips loading tables that have indexes that were set to the Index Unusable state.
- Regenerate Object IDs: Select to create new object identifies for the imported database objects.
- Delete Master Table: Select to indicate whether the Data Pump control job table should be deleted or retained at the end of an Oracle Data Pump job that completes successfully.
- Overwrite Existing Datafiles: Select to indicate that if a table already exists in the destination schema, overwrite it.
- Version: Select the version of database objects to import.
- Logging: Select to create a log file. Enter the log directory and log file name.
Click Next.
- The Summary step displays a summary of all the selections made in the previous
steps.
Select Show Code at the bottom to see the PL/SQL code equivalent of the form.
Click Import.
The start of the job execution is displayed on the Data Pump page.