Hi Gurus,
Can anyone help me in this Regard.

ORA-29879
SQL> CREATE INDEX CHECK_INDEX_1 ON GOODS(DESCRIPTION) INDEXTYPE IS ctxsys.context;

ORA-29879 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


Note: I need to use this Index type as I use Contains clause in my query and I cant change my column for this. As by using this column, my query is going to work.

Can any one help me in this regard.

Thanks,
Kumar