Re: Need help performing large updates...

When you setup a cursor (which needs read snapshot) and update rows with commit while fetching from cursor - your RBS requirement goes down but you are sure to get the famous ORA-1555 snapshot too old which happens to me all the time.

Try update with where rownum <= 10000 (or some number that your RBS can support) and run this update repeatedly.

Sameer.

Bo Lu <bo.lu_at_hsc.utah.edu> wrote:

>I run into this problem several month ago. Instead of do the update
>within ONE SQL statement, you use PL/SQL to do the update for each
>records. You can setup a counter and commit each 10,000 records.
 

>--
>Bo Lu
>Programmer/Analyst
>Hospital and Clinical Informatics, U. of Utah
>Phone: 801-581-5964, E-Mail: bo.lu_at_hsc.med.utah.edu