Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Update in multiple chunks

913578Dec 21 2018 — edited Jan 3 2019

Hi,

I want to update a table having 10million records.

It is a simple update, but as the roll back segment area is limited i wanted to update them in multiple chunk i.e 1lac record each and commit.

how do i do that.

Thanks.

Comments
Post Details
Added on Dec 21 2018
19 comments
4,076 views