A tablespace allows superusers to define an alternative location
on the file system where the data files containing database
objects (such as tables and indexes) may reside.
Create a Tablespace
To create a tablespace :
- Select the Database in the Tree View and select Others
>
Tablespace from the toolbar
- Press the
New Tablespace button
- Enter Tablespace properties and fields on the appropriate
tabs of the New Tablespace Editor
- Click OK
Design a Tablespace
To design a tablespace:
- Select the Database in the Tree View and select Others
>
Tablespace from the toolbar
- Select the tablespace you want to design.
- Press the
Design Tablespace button.
- Edit Tablespace properties and fields on the appropriate
tabs of the Design Tablespace Editor
- Click OK
Delete a Tablespace
To delete a tablespace:
- Select the Database in the Tree View and select Others
>
Tablespace from the toolbar
- Select the tablespace you want to delete.
- Click the
Delete Tablespace button.
- Confirm deleting in the dialog window.
|