RelationalDBDesign
RedhatLinuxSys Seomining
prev prev
Course navigation
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.
Course navigation