Skip to Main Content

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question, Pooja.

Asked: September 02, 2022 - 2:24 am UTC

Last updated: September 06, 2022 - 5:47 am UTC

Version: Oracle19c

Viewed 1000+ times

You Asked

We have a table with around 150+ million records and our database is setup with two nodes on rac. We can’t do no logging as it’s default setup with logging in prod.

We have a requirement to add two columns for this big table and we need to perform update operation for existing records based on another table.

What is the best approach to achieve this with logging.

and Connor said...

Your options are typically:

- CTAS
- DBMS_REDEFINITION
- Parallel DML
- DBMS_PARALLEL_EXECUTE

Check out Chris's "All About Update" video which discusses some options when it comes to large updates at around the 45minute mark

https://youtu.be/xjEh-AQN4FE


Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

More to Explore

PL/SQL demos

Check out more PL/SQL tutorials on our LiveSQL tool.

PL/SQL docs

PL/SQL reference manual from the Oracle documentation library