History Correction [message #342306] |
Fri, 22 August 2008 00:11  |
gauravsunil
Messages: 68 Registered: August 2007 Location: bhubaneswar
|
Member |
|
|
Hi,
I have to do history data correction in table having 1 billion record, I have to do correction between 3 months timestump.
There is index on that time stump.
Please advice, what should be the best way to go for it.
Thanks and regards,
Gaurav
|
|
|
|
|
|
|
|
Re: History Correction [message #342353 is a reply to message #342350] |
Fri, 22 August 2008 02:01   |
gauravsunil
Messages: 68 Registered: August 2007 Location: bhubaneswar
|
Member |
|
|
Michel, I want your advice on it for whether I go for update in chunk or I take the whole date interval and go for update.
Please suggest me on it.
Regards,
Gaurav
|
|
|
|
|
|
Re: History Correction [message #342784 is a reply to message #342772] |
Mon, 25 August 2008 01:30  |
 |
Michel Cadot
Messages: 68761 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
idris.ali wrote on Mon, 25 August 2008 08:08 | Hi
I think , You may choose a commit size of around 500,000
Use bulk operations in plsql to achieve this.
Thanks,
Idris
|
Why?
Regards
Michel
|
|
|