Skip to Main Content

Oracle Database Discussions

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!

Get storage size of CLOB column within a table

Chaka1313Aug 28 2019 — edited Aug 29 2019

Hi all!

We are experiencing an issue where tons of rows are being inserted within a clob column and we are trying to determine what the size of the entire column is. We have the table size, but we'd like to know just how much this one column is taking up so that we can shrink it down and reduce the space within that table. Is there a query that anyone can provide that can determine this?

Comments
Post Details
Added on Aug 28 2019
11 comments
7,058 views