Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

bulk update OR sql update

user10647455Sep 15 2011 — edited Sep 19 2011
Hello All,
Oracle 11g
I am trying to understand pro's and con's for bulk update.
I have a table contains 4-5 million rows, which are going through some business rule and based on those we are doing an update for few columns.
Also there is an special scenario where i look for duplicate row in the table so when i see a dup i mark as "U" while the first occurrence marked as "I".
Something like
TABLE A
Col1     Col2    Col3 ....... Col15
1           L       K              I
1           L       K              U
2           J       P              I
1           L       K              U

........
Now my question Is bulk update suitable on this situation because currently we have normal process (cursor with 50000 commit limit). and it take around 2 hours to complete.

Any suggestions/idea will be helpful.

Thanks!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 17 2011
Added on Sep 15 2011
22 comments
1,967 views