ALTER TABLESPACE
Change the properties of a tablespace.
Syntax:
ALTER TABLESPACE tablespace_name optionoptions:
The option used with this command can be any one of the following
ADD {TEMPFILE|DATAFILE} 'filespec' [AUTOEXTEND OFF] SIZE int {K|M}
ADD {TEMPFILE|DATAFILE} 'filespec' SIZE int {K|M}
[ AUTOEXTEND ON [NEXT int K | M]
[MAXSIZE {UNLIMITED|int K|int M}] ]
RENAME DATAFILE 'filename' TO 'filename'
{TEMPFILE|DATAFILE} ONLINE
{TEMPFILE|DATAFILE} OFFLINE
MINIMUM EXTENT int {K|M}
COALESCE
DEFAULT STORAGE storage_clause
ONLINE
OFFLINE {NORMAL | TEMPORARY | IMMEDIATE}
{BEGIN | END} BACKUP
READ {ONLY | WRITE}
PERMANENT | TEMPORARY
LOGGING | NOLOGGING
[NO] FORCE LOGGING
DBMS_SPACE_ADMIN
CREATE TABLESPACE
DROP TABLESPACE
