Re: How to delete cluster or index?

Oracle DB Owner <afilonov_at_pro-ns.net> wrote:
> "Ching X. Xu" wrote:
 

>> SQL*PLUS,  under command line mode, we can drop a table, view.
>> But how can we drop a created cluster or index?  And how to show
>> all created cluster, bitmap or index?
 

> Same way. SQL statements are drop cluster and drop index. To list all
> indexes, use dba_indexes view,
> for clusters, dba_clusters.

        Firstly you have to drop all members of cluster and then is posible to drop cluster.

                Starous Received on Thu Feb 15 2001 - 09:41:37 CET