Creating a cluster
CREATE CLUSTER
CREATE CLUSTER
| CREATE CLUSTER | Required keywords. | |
| cluster_name | The unique name for the cluster. | |
| column_name | The name of the column or columns that will make up the cluster key. These names are unique to the cluster, but they do not have to match the names of the corresponding columns in the clustered tables. | |
| DATATYPE | One of the standard Oracle column datatypes, except for LONG RAW and RAW. Although the names of the columns in the clustered table do not have to match the -column_name, the datatypes of the corresponding columns do have to match. | |
| SIZE | A required keyword. | |
| size_value | The size of the cluster needed to store all the rows with the same value for the cluster key. Sizing a cluster is discussed in more detail in the next lesson. | |
| storage_clause | Contains the same types of storage options as the storage clause for a table, such as TABLESPACE and PCTFREE. |