Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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 GroupReceived on Wed Sep 13 2006 - 08:20:00 CDT