DROP_AUTOCOMPLETE_INDEX

DBMS_SEARCH.DROP_AUTOCOMPLETE_INDEX procedure removes the autocomplete index and cleans up associated objects.

Syntax

DBMS_SEARCH.DROP_AUTOCOMPLETE_INDEX(
   index_name   VARCHAR2,
   source_name  VARCHAR2
);

index_name

Name of the autocomplete index to drop.

source_name

Name of the source table used by the autocomplete index.

Example

This example removes the autocomplete index named MOVIES_AC_IDX from the MOVIES_JSON table.

BEGIN
  DBMS_SEARCH.DROP_AUTOCOMPLETE_INDEX(
    index_name  => 'MOVIES_AC_IDX',
    source_name => 'MOVIES_JSON'
  );
END;
/