We have an overnight job that runs a number of text queries against the
database (WHERE contains('x','y')>0)
Occasionally, one or more of these queries generates an error -
ORA-29903: error in executing ODCIIndexFetch() routine
ORA-20000: ConText error: DRG-50857: oracle error in drekrgm (reselect
rowid row locator)
ORA-01054: user storage address cannot be written
When we retry the query in the morning it works OK. Any ideas on where we
should start looking?
Alan Brown
Millstream Associates Limited