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

On 13 Sep 2006 01:45:54 -0700, 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...

Look at it this way:
the FETCH approach gets 80-90 million records in buffer cache, and transmitted to your pga.
The INSERT SELECT approach transmits 0 records to your PGA. Which one is faster?

--
Sybrand Bakker, Senior Oracle DBA