Tablespace: General Page

The General page of the Tablespace property sheet contains fields that define the tablespace. These fields are described below:

Name

Name of the tablespace to be created. Enter the name of the new tablespace. The tablespace name can only contain characters from your database character set and can be at most 30 characters long.

Status

Status of the tablespace to be created:

Note: The Read Only option is disabled if there are any open transactions in the database or any active rollback segments in the tablespace.

Datafiles

Multi-column scrolling list of the datafiles belonging to the tablespace. The columns include Name, Status, Size (M), and Used (M). These are the same columns as those in the Datafiles multi-column list.

Add

Displays the Datafile property sheet, which allows you to specify each new datafile belonging to the new tablespace. When you create a new datafile, the status column in the datafile list reads NEW.

Remove

Removes the datafile selected in the Datafiles scrolling list. You can also press the Delete key to remove a selected datafile. You can only remove a datafile that has been newly created and has not been committed to a tablespace.

Edit

Displays the Edit Datafile property sheet, which allows you to edit the file specification for the datafile selected in the Datafiles scrolling list. This property sheet is the same as the Create Datafile property sheet.

Type

Permanent: Specifies that the tablespace will be used to hold permanent database objects. This option is selected by default.

Temporary: Specifies that the tablespace will only be used to hold temporary objects (sort segments). No permanent object can reside in a temporary tablespace.

Attention: This option is only available for Oracle7 release 7.3 or higher. For more information on temporary tablespaces and their application, see Oracle Server Concepts.