CREATE TABLESPACE

Create a tablespace.

Syntax:

   CREATE [UNDO] 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 [COMPRESS|NOCOMPRESS] STORAGE storage_clause
    MINIMUM EXTENT int {K|M}
    BLOCKSIZE int K
    LOGGING | NOLOGGING
    FORCE LOGGING
    ONLINE | OFFLINE
    PERMANENT | TEMPORARY
    EXTENT MANAGEMENT {DICTIONARY |
       LOCAL {AUTOALLOCATE | UNIFORM [SIZE int K | M]} }
    SEGMENT SPACE MANAGEMENT {MANUAL | AUTO}

"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