Oracle Indexing Issue - Help Required - Urgent
Can anyone help me in this Regard.
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.