Skip to Main Content

Breadcrumb

XMAS_TREE

The AskTOM team is taking a break over the holiday season, so we're not taking questions or responding to comments. Please have a happy and safe festive season and as always, thanks for being a member of the AskTOM community.

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)

We're not taking comments currently, so please try again later if you want to add a comment.
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

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