CREATE/ALTER/DROP CLUSTER
						
						
						
						CREATE CLUSTER [schema.]clustername 
  (column
						datatype[, column  datatype ...])
  [Physical_Attributes_Clause]
  [SIZE integer [K | M]]
  [TABLESPACE tsname]
  [STORAGE Storage_Clause]
  [INDEX]
  [[SINGLE TABLE] HASHKEYS integer HASH IS expression]
  [{PARALLEL [integer] | NOPARALLEL}]
  [CACHE | NOCACHE]

Creates a cluster, which is a schema object containing one or more tables with one or more columns in common.

ALTER CLUSTER [schema.]clustername
[SIZE integer[K | M]]
[Physical_Attributes_Clause]
[STORAGE Storage_Clause]
[{PARALLEL [integer] | NOPARALLEL}]
[ALLOCATE EXTENT 
 (EXTSIZE integer[K | M] [DATAFILE 'filename'] [INSTANCE integer])]

Redefines future storage allocations or allocates an extent for a cluster.

DROP CLUSTER [schema.]clustername
[INCLUDING TABLES]
[CASCADE CONSTRAINTS]

Removes a cluster from the database.

Keywords

cluster_name

Specifies the name of the cluster.

column

Specifies the name of the column that defines the cluster key.

datatype

Specifies the datatype of the column.

PCTUSED

Changes the minimum percentage of used space that Oracle will maintain in each block. Values can range from 0 to 99, and the default is 40.

PCTFREE

Changes the percentage of space kept free for future updates to the rows contained in this cluster. Values can range from 0 to 99, and the default is 10.

INITTRANS

Changes the number of transaction entries allocated to each block in the cluster. Values can range from 1 to 255, but should not normally be changed from the default ...

Get Oracle SQL: the Essential Reference now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.