-
Oracle Indexing Issue - Help Required - Urgent
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|