Using Record Type
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
Software/Hardware used:
Software/Hardware used:
ASKED:
May 22, 2004 7:44 AM
UPDATED:
May 26, 2004 3:34 PM
RELATED QUESTIONS
Answer Wiki:
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.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
