Question: how to create ctxcat index oracle?
Answer: In order to create the index we must create an index-set with a sub-index for each column referenced by the CATSEARCH function. EXEC CTX_DDL. CREATE_INDEX_SET('my_items_iset'); EXEC CTX_DDL. ADD_INDEX('my_items_iset','price'); CREATE INDEX my_items_name_idx ON my_items(description) INDEXTYPE IS CTXSYS.