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.
Click Here to Expand Forum to Full Width