Re: PL/SQL and Snapshot too old

Dan Townsend <townsend_at_ebmud.com> wrote:

>I thought I understood 'Snapshot too old' from my earlier incarnation as
>a DBA, but this one seems odd. We have a nightly process that first
>deletes about 100,000 rows from a (much larger) table, then inserts rows
>to replace them (refreshing an external data source). To avoid blowing
>out the rollback segments, our developer performs the deletes in batches
>that are committed (no problems), then does the inserts in a PL/SQL loop
>that commits every 'n' records.
 

>...
>Can anyone explain this or help us resolve it? Thanks.
>+-----------------------------------------------------
>| Dan Townsend, Supervising Database Architect
>| EBMUD Enterprise Object Designer
>| mailto:townsend_at_ebmud.com
>+-----------------------------------------------------

Force your transaction on a reserved rollback segment as large as your original table. Received on Mon Apr 07 1997 - 00:00:00 CDT