Drop Oracle Cluster[Syntax]

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.