ALTER TABLESPACE

Change the properties of a tablespace.

Syntax:

   ALTER TABLESPACE tablespace_name option

options:
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

"God grant us the serenity to accept the things we cannot change, courage to change the things we can, and wisdom to know the difference." - Reinhold Niebuhr - The 12 step program

Related Commands:

DBMS_SPACE_ADMIN
CREATE TABLESPACE
DROP TABLESPACE

Related Views:

 DBA_DATA_FILES 
 DBA_TABLESPACES                           USER_TABLESPACES 
 DBA_TEMP_FILES 
 DBA_TS_QUOTAS                             USER_TS_QUOTAS