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..