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 up queries. That worked for us until we started deleting selected Documents. Now (Cache) gives us the large query performance boost we wanted, albeit with a significant, though acceptable (30-40%), increase in time taken for index re-syncs. Hope this helps someone. Jack -------------------------------- Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -----Original Message----- Applewhite Sent: Wednesday, September 12, 2001 7:40 PM To: Multiple recipients of list ORACLE-L 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" for Contains queries and ORA-600 [12700] errors in the Alert log. This happened a few days after we altered the DR$<index>$R table to Cache Reads for its Data LOB column. Metalink Bug 1668041 indicates that changing Cache Reads to just Cache for the DR$...$R table solved the problem for an 8.1.7. WinNT DB. Has anyone else experienced this? I'm rebuilding the index now (for the 2nd time this week! - takes 7.25 hours) and want to know if this fix will work. Thanks for any advice or suggestions. Jack -------------------------------- Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
