Online Documentation for SQL Manager for Oracle

Setting export options


Specify common export options according to your needs.

 

CheckBox Replace non-print characters in strings with spaces

Select this option to insert spaces instead of non-print characters.

 

CheckBox Quote identifiers

With this option ON all reserved words are enclosed in quotation marks.

 

CheckBox Use multi insert statements

Use the option to allow multi insert statements in the result script.

Note: The option is active available when destination server selected at the first step is different from Oracle. Before using the  result script make sure that destination server supports such statements.

 

Data options

Records in block

Use the spinner control to define the number of records in each committed block.

 

CheckBox Insert COMMIT after each block

Check this option to add the COMMIT statement after a defined number of records.

 

Export as SQL Script - Setting export options

 

Click the Next button to proceed to Exporting as Execute Script.