To
create a tablespace:
Click the Tablespaces object in the tree. The Tablespaces page is displayed

Click the Create button in the Tablespaces window. The Create Tablespace Wizard window is opened.

Click the Next button. The Name the Tablespace window is displayed.

Enter the name of the tablespace in the Tablespace Name field.
Select a tablespace type:
select a regular tablespace, select the Regular option button.
select an Auto-Extend tablespace, select the Auto-Extend option button.
Click the Next button. The Add file to the Tablespace window is displayed.

Enter the logical name of the tablespace in the Logical Name column.
Enter the physical name of the tablespace in the Physical Name column.
Note: You can also select the physical name of the tablespace from a list by clicking the Browse button.
Enter the size of the tablespace in the Size column.
Select the tablespace type from the Type column.
Set the file offset for raw devices in the Offset column.
NOTE This option is active only for databases running in a Unix environment.
Click the Next button to proceed. The wizard will display the SQL command for creating a new tablespace. This command can be edited.

To edit the command, enter or delete command syntax in the command line area.
Click the Finish button. The Information window of the Create Tablespace Wizard is displayed.

Related topic: