Using Record Type

pts.
Tags:
Oracle 9i
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. Any suggestions. Regards

Answer Wiki

Thanks. We'll let you know when a new response is added.

Can the tables be exactly the same? Can you use Oracle’s snapshots to replicate only the differences over each night? In a previous shop, we had a reporting database with a table for ITD data, another for Prior Year and then the snapshot of the current production data. We used views to join the tables for various reports.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: