Choose your database:
AnySQL
MySQL
MS SQL Server
Oracle
PostgreSQL
SQLite
Firebird
SQL Anywhere
DB2
MaxDB

Subscribe to our news
Partners

ASA Data Wizard online Help

Prev Return to chapter overview Next

Data Pump

Creating error behavior

Select the action to be executed when an error occurs on creating a schema object.

 

Importing error behavior

Select the action to be executed when an error occurs during the data importing.

 

  Convert names to SQL92 standard

Check this option to convert all source object names to SQL92 standard when generating the target script.

 

  Confirm target object changes

With this option checked, Data Pump Wizard requests a confirmation each time you change any properties of the target database object.

 

  Select all import tables default

With this option checked, all tables are selected for data import by default at the Import data tables step. If this step is hidden, data of all tables are imported during the pumping process.

 

 

Replacements

Use this list to replace some definite source object names with other names when converting them to the target database, e.g. object names, which cannot be converted to SQL92 standard.

 

Click Add to add a replacement item and set the expected source object name as Text to find and the required target object name as Replace with. Check Ignore case to search source objects without case sensitivity.

 

Use the Edit and Delete buttons to edit and delete the replacement items respectively.

 



Prev Return to chapter overview Next