Online Documentation for SQL Manager for Oracle

Creating database scripts


At the final step of the wizard you need to specify script generation options and some additional settings.

 

If the RadioButton OLTP, RadioButton General purpose, or RadioButton Data warehouse database template is specified at the Specifying memory parameters step of the wizard, you should specify script directory, generation options and other options.

 

Create Database Wizard - Creating DB scripts

 

Script directory

Use this field to specify the CREATE DATABASE script location.

 

Generation options

RadioButton Run script now

Select this option execute the generated script to create the database immediately.

 

RadioButton Generate scripts

Select this option to generate database creation scripts for future use.

 

In case you intend to CheckBox Create sample scheme, CheckBox Create JServer scheme, CheckBox Enable database replication, CheckBox Install SQL*Plus Help, enable the corresponding options.

 

 

If the RadioButton Standby database template is specified at the Specifying memory parameters step of the wizard, you should specify script directory and options specific for a standby database.

 

Create Database Wizard - Creating DB scripts - Standby database

 

Script directory

Use this field to specify the CREATE DATABASE script location.

 

You need to specify Standby archive destination, Fal server and Fal client to finish database customization.

 

When all settings are done, click the Run button to complete the operation.