|Oracle8i SQL Reference
Release 3 (8.1.7)
Part Number A85397-01
CREATE SYNONYM to DROP ROLLBACK SEGMENT, 13 of 31
CLUSTER clause to remove a cluster from the database.
You cannot uncluster an individual table. Instead you must perform these steps:
RENAMEstatement to give the new table the name of the old one.
The cluster must be in your own schema or you must have the
CLUSTER system privilege.
Specify the schema containing the cluster. If you omit
schema, Oracle assumes the cluster is in your own schema.
Specify the name of the cluster to be dropped. Dropping a cluster also drops the cluster index and returns all cluster space, including data blocks for the index, to the appropriate tablespace(s).
TABLES to drop all tables that belong to the cluster.
CONSTRAINTS to drop all referential integrity constraints from tables outside the cluster that refer to primary and unique keys in tables of the cluster. If you omit this clause and such referential integrity constraints exist, Oracle returns an error and does not drop the cluster.
This statement drops a cluster named
geography, all its tables, and any referential integrity constraints that refer to primary or unique keys in those tables: