Re: Oracle Snapshot Too Old during programatic load

if your doing a 'programmatic load' you should consider doing one commit. if you have the rollback space for it.

This is what is happening.

your 'load' is doing DML on the table
another dml or query is operating on the table. you do a commit, the before image it was using gets overwritten.

if your running this load in parallel where you are doing DML on the same table at the same time, then this is your problem.
>
> From: "Smith, Ron L." <rlsmith_at_kmg.com>
> Date: 2003/07/28 Mon PM 12:09:24 EDT
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Subject: Oracle Snapshot Too Old during programatic load
>
> 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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <rgaffuri_at_cox.net
  INET: rgaffuri_at_cox.net

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).