We have a table with 70 columns and everyday we move data from thsi table to its history table which is basically same in structure. The daily table has about 4 million records that is tranferred to the history table.
To move data from this daily table to the hostory table we are using bulk collect and the implementation of bulk collect is done using record type variable.
Our problem is we when the procedure is executed it does not return back and we are getting a end of comminication end.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!