Oracle Snapshot Too Old during programatic load

From: Smith, Ron L. <rlsmith_at_kmg.com>
Date: Mon, 28 Jul 2003 08:09:24 -0800
Message-ID: <F001.005C77C8.20030728080924@fatcity.com>

I asked this last week, but I have a little more info this week.

I have a table that gets programmatically loaded each night. The table needs to have an index added for reporting purposes. However, when I add the index to the table in the TEST database I start getting Snapshot Too Old errors. I added 25% more space to the RBS tablespace but it didn't do any good. I also tried reducing the frequency of commits as suggested in Oracle papers but I still get the same error. If I remove the index, the load works fine.

Any ideas?

Thanks!
Ron Smith

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Smith, Ron L.
  INET: rlsmith_at_kmg.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

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 Jul 28 2003 - 11:09:24 CDT