Oracle SQL: the Essential Reference

CREATE/ALTER/DROP TABLESPACE

CREATE TABLESPACE tablespace_name DATAFILE 'filename` [SIZE integer [K | M] [REUSE]] [Autoextend_Clause] [,'filename` [SIZE integer [K | M] [REUSE]] [Autoextend_Clause]] DEFAULT STORAGE Storage_Clause [ONLINE | OFFLINE] [PERMANENT | TEMPORARY] [LOGGING | NOLOGGING] [MINIMUM EXTENT integer]

Creates a new tablespace, optionally specifying default storage characteristics for objects subsequently created in the tablespace.

ALTER TABLESPACE tablespace_name
  {
   [ADD DATAFILE filename [SIZE integer [K | M]] [REUSE]]
   [Autoextend_Clause]
   [RENAME 'filename1' TO 'filename2']
   [DEFAULT STORAGE Storage_Clause
   [ONLINE] |OFFLINE] 
   [PERMANENT | TEMPORARY]
   [BEGIN BACKUP | END BACKUP]
   [LOGGING | NOLOGGING]
   [MAXIMUM EXTENT integer]
  }

Changes an existing tablespace by adding or changing datafiles, changing storage parameters, taking the tablespace offline, putting the tablespace online, placing it in backup mode, or taking it out of backup mode.

DROP TABLESPACE tablespace_name
   [INCLUDING CONTENTS] [CASCADE CONSTRAINTS]

Removes a tablespace from the database.

Keywords

DATAFILE

Specifies the name of the operating system datafile for this tablespace. SIZE is required unless the file already exists. If the file does already exist, the REUSE keyword must be specified.

DEFAULT STORAGE

Specifies the physical storage characteristics. See Chapter 4 for detailed information.

ONLINE

Brings the tablespace online after creation. This option is the default.

OFFLINE

Leaves the tablespace ...