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