Skip to Main Content
  • Questions

  • Best way to add the 60 CLOB columns to the oracle table with around 17TB in size.

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question, Ojas .

Asked: April 16, 2025 - 8:03 am UTC

Last updated: April 22, 2025 - 12:15 pm UTC

Version: 19.26

Viewed 1000+ times

You Asked

Hi Team,

This is the first time I am asking question on asktom, while I am very much thankful to the solutions you have provided and kept helping people always.

We want to add 60 CLOB columns to the table which is around 17TB in size. This is a datawarehouse DB and data loading to this table is completely stopped now, as the source table of MS SQL Server has 60 additional columns to it. Kindly suggest the best and efficient way to add the column to the table.

The table is partitioned one.

Regards
Ojas

and Chris said...

Just add them!

This is a fast, nonblocking operation if they don't have default values.

If they do have defaults, add the column first. Then modify it to have a default. This won't back-populate the default for existing rows, which will be a challenge if you need to do this. If this is necessary, let us know.

Rating

  (2 ratings)

Comments

Sql gym

Syed Shahabaz A, April 20, 2025 - 3:42 am UTC

Please tell me how can I get my certificate I have already submitted all exercises and also whenever iam going to access the grade card it's showing as contact with administrator please provide me course completion certificate which it helps me to build my resume
Chris Saxon
April 22, 2025 - 12:15 pm UTC

If you have questions or comments about Oracle Dev Gym, please use the Feedback option on the Dev Gym site itself. It's available from the top-right menu when you're logged in
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

CLOB/BLOB/etc

Complete documentation on Securefiles and Large Objects here