Re: Rollback segent too small

First of all Please Read the Oracle Error Description from Documentation!

This could happen if you have a long query and you lost the rollback information you need.
Because in your ETL program there might be massive transaction which might be changing the data and One of the Transaction require Rollback Data which is being over written by some transaction. So you get "Snapshot too old message"

to aviod the Situation you should create a Rollback Segement Which can handle the amount of changing data . for that you should query V$ROLLSTAT view.
Then set a Specific Transaction to use a Specific Rollback Segementin single user mode and then find out the Difference of bytes use(for rollback information) before and after the Transaction and then estimate the size of your Rollback Segement.

Faheem Rao

nsouto_at_optushome.com.au.nospam (Nuno Souto) wrote in message news:<3bc6ea60.10455113_at_news>...
> In a valiant and sublime effort,Michiel Brunt
> dipped a thumbnail in soot and doodled:
>
> >
> >Our ETL tool commits every 10.000 records.
> >However, after 8 mln records I receive the message:
> >
> >Error: ORA-01555: snapshot too old: rollback segment number 2 with name
> >"RBS1" too small
> >
> >I cannot explain this as it should be able to extend automatically (physical
> >disk is NOT full)
> >
>
>
> You sure no one else is reading off that same table? Even the ETL
> tool itself?
>
> Cheers
> Nuno Souto
> nsouto_at_optushome.com.au.nospam
Received on Fri Oct 12 2001 - 14:36:35 CDT