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!

text index CTXSYS.CTXCAT problem

722087Dec 5 2011 — edited Dec 5 2011

i am using oracle 10g release2....

i am using text index in one of my table syntax is like this

CREATE INDEX myindex ON TEST_SEARCH(text) INDEXTYPE IS CTXSYS.CTXCAT;

i saw in oracle-base site that CTXSYS.CTXCAT search is transctional not requires synchronozation

But somtimes i am getting problem like this

Please Try again,Invalid InputORA-20000: Oracle Text error:
DRG-50857: oracle error in dreii1fsh
ORA-00942: table or view does not exist

ORA-06512: at 'CTXSYS.DRUE', line 160
ORA-06512: at 'CTXSYS.DRVDML', line 426
ORA-06512: at

after that i dropped the index and again create its working fine.plz help wil it be any problem in future if i wil use this
index it does not required synchronization.
thanks in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 2 2012

Added on Dec 5 2011

#database-key-features, #text

2 comments

605 views