|
|
DROP INDEX
Drop an index.
Syntax:
DROP INDEX [schema.]index [FORCE]
Force can be used to drop domain indexes that are marked
as 'loading' or are reporting errors.
Related Commands:
INDEX - CREATE INDEX
INDEX - ALTER INDEX
Related Views:
DBA_INDEXES ALL_INDEXES USER_INDEXES INDEX_HISTOGRAM INDEX_STATS DBA_INDEXTYPES ALL_INDEXTYPES USER_INDEXTYPES DBA_INDEXTYPE_OPERATORS ALL_INDEXTYPE_OPERATORS USER_INDEXTYPE_OPERATORS DBA_IND_COLUMNS ALL_IND_COLUMNS USER_IND_COLUMNS DBA_IND_EXPRESSIONS ALL_IND_EXPRESSIONS USER_IND_EXPRESSIONS DBA_IND_PARTITIONS ALL_IND_PARTITIONS USER_IND_PARTITIONS DBA_IND_SUBPARTITIONS ALL_IND_SUBPARTITIONS USER_IND_SUBPARTITIONS