Oracle8i SQL Reference Release 2 (8.1.6) A76989-01 |
|
SQL Statements (continued), 6 of 30
To remove an index or domain index from the database.
See also:
|
The index must be in your own schema or you must have the DROP
ANY
INDEX
system privilege.
schema |
is the schema containing the index. If you omit schema, Oracle assumes the index is in your own schema. |
|
index |
is the name of the index to be dropped. When the index is dropped, all data blocks allocated to the index are returned to the index's tablespace. If you drop a domain index:
|
|
|
If you drop a global partitioned index, a range-partitioned, or a hash-partitioned index, all the index partitions are also dropped. If you drop a a composite-partitioned index, all the index partitions and subpartitions are also dropped. |
|
|
applies only to domain indexes. This clause drops the domain index even if the indextype routine invocation returns an error or the index is marked |
This statement drops an index named MONOLITH
:
DROP INDEX monolith;
|
![]() Copyright © 1999 Oracle Corporation. All Rights Reserved. |
|