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

On 12 Sep 2006 07:56:22 -0700, spremuta_at_gmail.com wrote:

>do i have to change script in the lines:
>IF CONTATORE_COMMIT = FREQUENZA_COMMIT
> > THEN CONTATORE_COMMIT := 1;
> > COMMIT;
> > END IF;
>?
>deleting only commit line or all that lines in your opinion?

ALL that lines.
Better still : get rid of the entire for loop (as it fetches record by record) and convert this mess into a proper INSERT
SELECT statement

and forget about it.

--
Sybrand Bakker, Senior Oracle DBA