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

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.

Howdy, Stranger!

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