Oracle8i SQL Reference Release 2 (8.1.6) A76989-01 |
|
SQL Statements (continued), 9 of 10
To remove a cluster from the database.
You cannot uncluster an individual table. Instead you must
CLUSTER
clause,
RENAME
statement to give the new table the name of the old one, and
See "CREATE TABLE", "DROP TABLE", "RENAME", "GRANT system_privileges_and_roles".
The cluster must be in your own schema or you must have the DROP
ANY
CLUSTER
system privilege.
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:
DROP CLUSTER geography INCLUDING TABLES CASCADE CONSTRAINTS;
|
![]() Copyright © 1999 Oracle Corporation. All Rights Reserved. |
|