REMOVE_INDEX

Removes the index with the specified column list from a CTXCAT index set preference.

This procedure does not remove a CTXCAT sub-index from the existing index. To do so, you must drop your index and re-index with the modified index set preference.

Note: The Oracle Text indextype CTXCAT is deprecated with Oracle AI Database 26ai. The indextype itself, and it’s operator CTXCAT, can be removed in a future release.CTXCAT was introduced when indexes were typically a few megabytes in size. Modern, large indexes, can be difficult to manage with CTXCAT. The addition of index sets to CTXCAT can be achieved more effectively by the use of FILTER BY and ORDER BY columns, or SDATA, or both, in the CONTEXT indextype. CTXCAT is therefore rarely an appropriate choice. Oracle recommends that you choose the more efficient CONTEXT indextype.

Syntax

CTX_DDL.REMOVE_INDEX(

    set_name       IN VARCHAR2,
    column_list    IN VARCHAR2
    language       IN VARCHAR2 default NULL
);

set_name

Specify the name of the index set.

column_list

Specify the name of the column list to remove.