DROP INDEX
Note:
This section describes the DROP INDEX statement as it pertains to dropping a Text domain index.
For a complete description of the DROP INDEX statement, seeOracle Database SQL Language Reference.
Purpose
Use DROP INDEX to drop a specified Text index.
Syntax
DROP INDEX [schema.]index [force];[force]
Optionally forces the index to be dropped. Use the force option when Oracle Text cannot determine the state of the index, such as when an indexing operation fails.
Oracle recommends against using this option by default. Use it only when a regular call to DROP INDEX fails.
Example
The following example drops an index named doc_index in the current user’s database schema:
DROP INDEX doc_index;