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


Examples

Alter Tablespace TEMP ADD TEMPFILE 'T:\oradata\live\Temp02.DBF' SIZE 800M;

Alter Tablespace SS64 ADD DATAFILE 'T:\oradata\live\Data02.DBF' SIZE 1500M;

More examples - Morgans Library

"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


© Copyright SS64.com 1999-2013
Some rights reserved