Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


How to periodic commit in insert /*+ parallel () */ select Query??

rajumkrajumk Member Posts: 1
Hello every1,

I have a for cursor which inserts data into a table.

I have removed the cursor and trying to use insert/select and with parallel hint...

The problem is that the data is huge and it might result in rollback segment error, if I move it to production environment.

Is there any mechanisms of commiting inbetween (like for every 5k records)??

Any help will be greatly appreciated..

Sign In or Register to comment.