The General page of the Tablespace property sheet contains fields that define the tablespace. These fields are described below:
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 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.
If the status is Online and the database is Oracle7 release 7.1 or higher, 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 are any open transactions in the database or any active rollback segments in the tablespace.
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.
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.
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.
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.
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.