||Oracle Tips by Burleson
Indexes occasionally have to be dropped.
Sometimes they are built incorrectly or shouldn’t have been built at
all. Other times, especially in early Oracle7 releases (prior to
7.3), in order to rebuild an index it had to be dropped first.
Finally, dropping an index may be required to speed import or
SQLLOADER during large data loads.
The DROP INDEX Command
The DROP INDEX command has the following
See Code Depot
Of course, you must own the index or have
the DROP ANY INDEX privilege to drop an index. The FORCE clause only
applies to DOMAIN type indexes and forces a drop of the index even
if its status is LOADING or its invocation returns an error.