Online Documentation for SQL Manager for Oracle

Data storage and redo log settings


This step allows you to manage tablespaces and redo logs.

 

Note: This step is skipped if the RadioButton Standby database template is specified at the Specifying memory parameters step of the wizard.

 

Create Database Wizard - Data storage settings

 

 

Use the btnAddItem Add item button to add the corresponded item.

Use the btnRemoveItem Remove item button to delete the selected item.

 

Note: There are several system tablespaces that cannot be removed from the list: SYSTEM, UNDO, SYSAUX, TEMP.

 

The Add Tablespace allows you to define properties for a newly added tablespace.

 

Create Database Wizard - Data storage settings - Add tablespace

 

Tablespace name

Specify the name of the tablespace to be created.

 

File Name

Specify the tempfile to make up the temporary tablespace.

 

Size (Mb)

Specify the tablespace size (in megabytes).

 

 

Extent management

 

RadioButton Dictionary

Use this option if you want the tablespace to be managed using dictionary tables. In this case you should set the Default storage parameters.

 

RadioButton Locally

Select this option if you want the tablespace to be locally managed. Locally managed tablespaces have some part of the tablespace set aside for a bitmap.

 

 

Default storage

This group is available only for a locally managed tablespace. Using these controls you can specify the default storage parameters for all objects created in the tablespace: Initial extent, Next extent, Percent increase, Minimum extents, Maximum extents, Minimum extent size.

For more information see Storage attributes.

 

The Add Redo Log allows you to define properties for a newly added redo log file.

 

Create Database Wizard - Data storage settings - Add redo log

 

File Name

Specify the path and name of the redo log file to be added.

 

File size (Mb)

Specify the redo log file size (in megabytes).

 

Note: There should be no less than two redo logs in a database.

 

Click the Next button to proceed to the Creating database scripts step of the wizard.