CREATE TABLESPACE

Create a tablespace.

Syntax:

   CREATE TABLESPACE tablespace_name
      DATAFILE Datafile_Options Storage_Options ;
Datafile_Options:

    'filespec' [AUTOEXTEND OFF]
    'filespec' [AUTOEXTEND ON [NEXT int K | M] [MAXSIZE int K | M]]

The Autoextend Maxsize clause will default to UNLIMITED if no value is specified.

Storage_Options:

    DEFAULT STORAGE storage_clause
    MINIMUM EXTENT int {K|M}
    LOGGING | NOLOGGING
    ONLINE | OFFLINE
    PERMANENT | TEMPORARY
    EXTENT MANAGEMENT {DICTIONARY |
       LOCAL {AUTOALLOCATE | UNIFORM [SIZE int K | M]} }

"A place for everything and everything in its place" - Isabella Mary Beeton, The Book of Household Management

Related Commands:

ALTER TABLESPACE
DROP TABLESPACE

Related Views:

 DBA_DATA_FILES 
 DBA_TABLESPACES                           USER_TABLESPACES
 DBA_TEMP_FILES 
 DBA_TS_QUOTAS                             USER_TS_QUOTAS       




Back to the Top

Simon Sheppard
SS64.com