Skip to Main Content
Forums

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!

updating millions of rows in a partitioned table

957995May 14 2017 — edited May 15 2017

I need to create an update script to update a particular column(as_at) in a table. The table is having nearly 500 partitions and each partition is having millions of rows.I need to update the entire table. the table is partitioned on the basis of another column(as_of). Both are date columns. i can not go for CTAS. Any other idea to update the table.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 12 2017
Added on May 14 2017
8 comments
4,751 views