Drop an index.
Syntax:
DROP INDEX [schema.]index [FORCE]
FORCE can be used to drop domain indexes that are marked
as IN_PROGRESS or are reporting errors.
"Anything you build on a large scale or with intense passion invites chaos" ~ Francis Ford Coppola
Related Oracle Commands:
INDEX - CREATE INDEX
INDEX - ALTER INDEX
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