Tablespace: General Page

The General page of the Create Tablespace or Create Like 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.

Datafiles

Multi-column list of the datafiles belonging to the tablespace. The columns include File Name, File Directory, Size, and Used. To specify a new datafile belonging to the tablespace, type in the File Name, File Directory, and Size of the new datafile. You can choose mbyte or kbyte as the size unit.

The Used column does not appear in the Create Tablespace property sheet.

Note: For 8.1.5 and later databases, locally managed temporary tablespaces are called Tempfiles instead of Datafiles.

Edit (Pencil Icon)

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

Remove (Trashcan Icon)

Removes the datafile selected in the Datafiles list. You can right-click the selected datafile and choose Remove from the context-sensitive menu. You can only remove a datafile that has been newly added and has not been committed to a tablespace.

Status

Status of the tablespace to be created.

· If the status is Offline, select the radio button to change the status to Online.

· If the status is Online, select the radio button to display a pop-up menu with Offline Normal, Offline Temporary, Offline Immediate, or Offline For Recover options. Select one of the Offline options. Note: Online is the default in create mode.

· If the status is Online and the database is version 7.1 or later, a Read-Only option is also available. If a tablespace has read-only status, the Make Writeable menu option is enabled. When you select the Make Writeable menu option, the tablespace becomes both readable and writeable and the status is changed to online.

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

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 Oracle version 7.3 or greater. For more information on temporary tablespaces and their application, see Oracle Server Concepts.