RE: ORA-1410 on interMedia Text Index

From: Jack C. Applewhite <japplewhite_at_inetprofit.com>
Date: Mon, 17 Sep 2001 10:43:13 -0700
Message-ID: <F001.00390776.20010917092523@fatcity.com>

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
japplewhite_at_inetprofit.com
(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
japplewhite_at_inetprofit.com
(512)327-9068

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jack C. Applewhite
  INET: japplewhite_at_inetprofit.com

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: ListGuru_at_fatcity.com (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).

Received on Mon Sep 17 2001 - 12:43:13 CDT

RE: ORA-1410 on interMedia Text Index - SOLVED