Create any cluster & associated cluster index in any tablespace CURRENTLY ONLINE - Oracle Clusters

Discussion

• Nirja Shah   -Posted on 02 Sep 15
  - A cluster provides an optional method of storing table data.
  
  - A cluster is made up of a group of tables that share the same data blocks.
  
  - The tables are grouped together because they share common columns and are often used together.
  
  - If you have the proper privileges and tablespace quota, you can create a new cluster and the associated cluster index in any tablespace that is currently online.
  
  - Always specify the TABLESPACE option in a CREATE CLUSTER/INDEX statement to identify the tablespace to store the new cluster or index.
  
  - The cluster and its cluster index can be created in different tablespaces.
  
  - In fact, creating a cluster and its index in different tablespaces that are stored on different storage devices allows table data and index data to be retrieved simultaneously with minimal disk contention.

➨ Post your comment / Share knowledge