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!

How to check CLOB size?

846231Jul 17 2012 — edited Jul 17 2012
Hi all,

I have a table with 200 rows ONLY . But the size of the table is 1Gb. I thought It was overallocated but I found it has CLOB column.
How do I check if this 1Gb space was really fully used up? or are there some idle freespace not being used?
I am just estranged by this CLOB. Can a CLOB hold a jpeg image?


Thanks a lot,
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 14 2012
Added on Jul 17 2012
3 comments
807 views