Online Documentation for Data Pump for Oracle

Step 4 - Setting options


At this step of the wizard you can define pump options: database structure conversion options, options pertaining to schemas processing, SQL script execution, data import preferences, and perform source-to-target type mapping.

 

Step 4 - Setting options

 

Convert database structure options

This group of options allows you to customize database structure conversion process.

 

CheckBox Convert names to SQL92 standard

This option brings all the database object names to conformity with SQL92 naming rules.

 

Object names format

The drop-down list allows you to specify whether object names are to be converted to upper/lower case or left without changes (As Is).

 

CheckBox Convert default values

Check this option to convert the default values of the source database to default values for the destination database.

 

Schemas processing

This group of options allows you to specify how Oracle schemas will be processed by the application.

 

Use existing schema for import

Use the drop-down list to select the schema in the Oracle database where the source tables are to be pumped into.

 

Script options

This group of options allows you to customize the SQL script generation and its execution process.

 

CheckBox Enable comments

If this option is selected, comments will be included into the body of the script.

 

CheckBox Show "OK" for successfully executed statements

If this option is selected, records for successfully executed statements will be listed in the Script execution information area at Step 6.

 

CheckBox Always skip successfully executed statements

If this option is selected, all successfully executed statements will be skipped upon subsequent script execution.

 

CheckBox Generate "DROP TABLE" statements

Select the option to add the DROP statements for tables in the script.

 

CheckBox Stop script execution on error

If this option is checked, the script execution will be stopped if an error occurs.

 

Import options

This group of options allows you to customize data import process.

 

CheckBox Clear tables before import data

Select this option to empty the tables in the Oracle database before data import at Step 8.

 

CheckBox Quote source identifiers

This option enables/disables quoting source object identifiers.

If enabled, use the drop-down list to select the preferable value:

  • Default to use the default quotes for the data source being used;
  • one of available quoting patterns: "...", '...', `...`, [...], (...), {...}, <...>;
  • Custom to specify any other characters to be used as left/right quotes.

 

CheckBox Remove trailing spaces

If this option is checked, unused space at the end of source data strings will be cut off.

 

Press the Global type mapping button to open the Type mapping dialog allowing you to view and edit source-target data type correspondences.

 

When you are done, click the Next button to proceed to editing target objects.