Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-29897 when indexing multiple Column s

mpatzwahlDec 6 2019 — edited Dec 7 2019

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

This post has been answered by mpatzwahl on Dec 7 2019
Jump to Answer

Comments

Post Details

Added on Dec 6 2019
5 comments
848 views