Online Documentation for SQL Manager for Oracle

Customizing script options


This step allows you to customize common script options and data options for the extraction process.

 

Script options

CheckBox Calculate dependencies

This option determines objects' dependencies usage in the extraction process. If you check this option then dependencies of every object will be analyzed before the extraction process. At first objects that have no dependent objects are extracted and then objects that depend on already extracted objects are extracted.

 

CheckBox Generate DROP statements

Check the option to add the DROP statements for the extracted objects in the result script.

 

CheckBox Generate object grants statement

Check this option to add the GRANT statements to object definitions.

 

CheckBox Insert description

This option determines whether object description should be added to the generated script.

 

Extract Database - Customizing script options

 

Data options

Records in a block / CheckBox Insert "COMMIT" statement after each block

These controls allow you to define whether the COMMIT statement is added to the script or not, and to specify the number of records in each block to be supplemented with this statement.

 

CheckBox Delete existing records

Check this option if you want to delete data from the table after it is extracted.

 

CheckBox Abort extraction on error

This option determines whether the extraction process should be stopped or forced to continue if an error occurs.

 

Click the Next button to proceed to the last step of the wizard.