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 [INCLUDING TABLES] [CASCADE CONSTRAINTS];
| 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. |