729

CREATE
[ BIGFILE | SMALLFILE ]
{ permanent_tablespace_clause
| temporary_tablespace_clause
| undo_tablespace_clause
} ;

permanent_tablespace_clause::=
TABLESPACE tablespace
[ DATAFILE file_specification [, file_specification ]... ]
{ MINIMUM EXTENT size_clause
| BLOCKSIZE integer [ K ]
| logging_clause
| FORCE LOGGING
| ENCRYPTION tablespace_encryption_spec
| DEFAULT [ table_compression ] [ storage_clause ]
| { ONLINE | OFFLINE }
| extent_management_clause
| segment_management_clause
| flashback_mode_clause
}...
logging_clause ::=
{ LOGGING | NOLOGGING | FILESYSTEM_LIKE_LOGGING }
tablespace_encryption_spec::=
[ USING 'encrypt_algorithm' ]
extent_management_clause ::=
EXTENT MANAGEMENT LOCAL
[ AUTOALLOCATE
| UNIFORM [ SIZE size_clause ]
]
segment_management_clause ::=
SEGMENT SPACE MANAGEMENT { AUTO | MANUAL }
flashback_mode_clause ::=
FLASHBACK { ON | OFF }
temporary_tablespace_clause::=
TEMPORARY TABLESPACE tablespace
[ TEMPFILE file_specification [, file_specification ]... ]
[ tablespace_group_clause ]
[ extent_management_clause ]
tablespace_group_clause::=
TABLESPACE GROUP { tablespace_group_name | '' }
undo_tablespace_clause::=
UNDO TABLESPACE tablespace
[ DATAFILE file_specification [, file_specification ]... ]
[ extent_management_clause ]
[ tablespace_retention_clause ]
tablespace_retention_clause ::=
RETENTION { GUARANTEE | NOGUARANTEE }