|
|
|
CREATE CLUSTER
Create a cluster of tables.
Syntax:
CREATE CLUSTER schema.cluster(col1 type, col2 type...) options
options:
The options used with this command can be any
combination of the following
PCTUSED int
PCTFREE int
INITRANS int
MAXTRANS int
SIZE int K | M
TABLESPACE tablespace_name
STORAGE storage_clause
INDEX | [SINGLE TABLE] HASHKEYS INT [HASH IS expression]
PARALLEL parallel_clause [CACHE|NOCACHE]
If the PARALLEL clause is used it should be the last option.
Related Commands:
CLUSTER - ALTER
Related Views:
DBA_CLUSTERS ALL_CLUSTERS USER_CLUSTERS DBA_DATA_FILES