Hi, i´m new to Context and i couldn´t find a solution to my problem:
i want to set the context index on 3 Cols (2 Clob one varchar2) on Oracle xe 18c:
BEGIN
ctx_ddl.drop_preference('muso_multi_idx');
ctx_ddl.create_preference('muso_multi_idx', 'MULTI_COLUMN_DATASTORE');
ctx_ddl.set_attribute('muso_multi_idx', 'COLUMNS', 'tipp_text, tipp_ueberschrift, tipp_text_plsql');
END;
CREATE INDEX msix_tipp_plsql_context
ON muniq.msta_tipp_text(tipp_text)
INDEXTYPE IS CTXSYS.CONTEXT
PARAMETERS ('DATASTORE muso_multi_idx SYNC ( ON COMMIT )');
But i get the error:
CREATE INDEX muniq.msix_tipp_plsql_context
ON muniq.msta_tipp_text(tipp_text)
INDEXTYPE IS CTXSYS.CONTEXT
PARAMETERS ('DATASTORE muso_multi_idx SYNC ( ON COMMIT )')
Fehlerbericht -
ORA-29879: Mehrere Domainindizes können nicht mit demselben Indextyp auf einer Spaltenliste erstellt werden
29879. 00000 - "cannot create multiple domain indexes on a column list using same indextype"
*Cause: An attempt was made to define multiple domain indexes on the same
column list using identical indextypes.
*Action: Check to see if a different indextype can be used or if the index
can be defined on another column list.
Has anybody a solution for this ?
Thanks
Marco