Dropping an Index

Pre-8.1

In pre-8.1, you drop an index using CTX_DDL.DROP_INDEX.

8.1

In 8.1, you drop an index using the DROP INDEX command in SQL.

For example, to drop an index called newsindex, issue the following SQL command:

drop index newsindex; 

If Oracle cannot determine the state of the index, for example as a result of an indexing crash, you cannot drop the index as described above. Instead use:

drop index newsindex force;

See Also: To learn more about the DROP INDEX command syntax, see the Oracle8i interMedia Text Reference.