Re: -1555-ORA-01555: snapshot too old: rollback segment number 7 with name "_SYSSMU7$" too small

spremuta_at_gmail.com wrote:

> I don't know if an Insert is more efficient than a Fetch regarding
> tables that contains 80-90 milions of records, i haven't create the
> pl/sql script i posted, but i can change it if surely an insert is
> better...

If you are unable to move 80-90M rows due to hardware then you still do not want to use a cursor loop.

Go to Morgan's Library at www.psoug.org and look up ARRAY PROCESSING. Find the example labeled "FAST WAY 1." Change the LIMIT clause to optimize speed.

-- 
Daniel Morgan
University of Washington
Puget Sound Oracle Users Group