Hey guys,
I have been experimenting around with bulk collect in 11gr2..
I have millioms of records to deal with and very large tables.
Basically, my question is this. How do you use bulk collect when you have millions of records?
Everytime i try to use it to bulk collect into, i run out of memory.
So should i stick with the SQL engine when it comes to manipulating millions
of records? Is Bulk Collect maninly for insert, updates to be used for applications?
Been banging my head for a while with this. Can a Pl/SQL pro please
give me some pointers on this?