Oracle Database Administration: The Essential Refe

Name

ALTER TABLESPACE

Synopsis

ALTER TABLESPACE tablespace_name
   {
[ADD DATAFILE filename [SIZE
integer[K | M]] [REUSE]
[autoextend_clause] ]
[RENAME DATAFILE 'filename1' TO
'filename2']
   [DEFAULT STORAGE (
      [INITIAL integer[K | M] ]
      [NEXT integer[K | M] ]
      [MAXEXTENTS {integer | UNLIMITED} ]
      [PCTINCREASE integer]
      [FREELISTS integer]
      [FREELIST GROUPS integer] ]
      ) ]
   [ONLINE]
   [OFFLINE [NORMAL | TEMPORARY | IMMEDIATE]]
   [COALESCE]
   [MINIMUM EXTENT integer[K | M] ]
   [READ [ONLY | WRITE]
   [PERMANENT]
   [TEMPORARY]
   [LOGGING]
   [NOLOGGING]
   [BEGIN BACKUP]
   [END BACKUP]
 }

Changes an existing tablespace (tablespace_name) by adding or changing datafiles, changing storage parameters, taking the tablespace offline or putting it online, or starting and stopping backups.

Keywords

ADD DATAFILE

Adds a new operating system datafile to the existing tablespace. SIZE information is required unless the file already exists; in this case, the REUSE keyword must be specified.

autoextend_clause

Specifies whether a given datafile is able to be automatically extended when it runs out of free space. The syntax is shown in the later autoextend_clause section.

RENAME

Changes the name of a datafile as stored in the data dictionary. Note that the tablespace must be offline before this command is issued.

DEFAULT STORAGE

Changes the physical characteristics for objects subsequently created in this tablespace, as follows:

NEXT

Specifies the size of the next extent in bytes, kilobytes, or megabytes. If the value is not a multiple of the ...