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