RelationalDBDesign RelationalDBDesign

Clustering Tables   «Prev 

Dropping Hash Clusters

You can drop a hash cluster using the DROP CLUSTER statement:
DROP CLUSTER emp_dept;
A table in a hash cluster is dropped using the DROP TABLE statement. The implications of dropping hash clusters and tables in hash clusters are the same as those for dropping index clusters

Drop Oracle Cluster

DROP CLUSTER cluster_name

DROP CLUSTER Required keywords.
cluster_name The name of an existing cluster.
INCLUDING TABLES These keywords are not required if the cluster does not contain any tables. If the cluster does contain tables and these keywords are not included, an error is returned.
CASCADE CONSTRAINTS If the cluster contains columns that are the objects of FOREIGN KEY constraints, you must include these keywords to drop these constraints, or an error will be returned.