Home Oracle Commands

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 



Back to the Top

Simon Sheppard
SS64.com