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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following