Oracle8i SQL Reference
Release 2 (8.1.6)

A76989-01

Library

Product

Contents

Index

Prev Up Next

SQL Statements (continued), 9 of 10


DROP CLUSTER

Syntax


Purpose

To remove a cluster from the database.

You cannot uncluster an individual table. Instead you must

See "CREATE TABLE", "DROP TABLE", "RENAME", "GRANT system_privileges_and_roles".

Prerequisites

The cluster must be in your own schema or you must have the DROP ANY CLUSTER system privilege.

Keywords and Parameters

schema 

is the schema containing the cluster. If you omit schema, Oracle assumes the cluster is in your own schema.  

cluster 

is 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).  

INCLUDING TABLES 

drops all tables that belong to the cluster. 

CASCADE CONSTRAINTS 

drops 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. 

Example

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; 

Prev Up Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index