Re: Rollback segent too small

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 - 08:08:02 CDT