Hi,
Just a follow-up for you interMedia Text fans out there.
The statement below worked for us to eliminate the ORA-1410 and ORA-600
[12700] errors.
Alter Table DR$Our_CLOB_Index$R Modify LOB (Data) (Cache);
The interMedia Text Performance FAQ on TechNet recommends (Cache Reads) to
speed
Hi,
8.1.6.0.0 on Win2k with interMedia Text index on table of 4 million CLOB
documents. It's been in stable operation for over 8 months, with approx.
70,000 documents being added daily, approx. 10,000 deleted daily, and a sync
of the index each day.
We started getting ORA-1410 invalid ROWID
I was getting ORA-600 [12700] when I upgraded a 734 text database to 817.
Ended up having to apply the latest patchset, I think it was 8172, to
finally fix the problem. Has something to do with buffer cache corruption
when Intermedia is trying to sync the index. The index loses its pointer to