DROP_INDEX

The DBMS_SEARCH.DROP_INDEX procedure removes a DBMS_SEARCH index and all its associated data from the database.

Syntax

DBMS_SEARCH.DROP_INDEX(
  INDEX_NAME VARCHAR2);

index_name

Specify name of the index that you want to drop.

Example

exec DBMS_SEARCH.DROP_INDEX('MYINDEX');

Related Topics