Skip to Main Content
Forums

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!

rBlob

773821Jul 7 2011 — edited Jul 7 2011
Hello

I have a little question. I have a lobsegment and the size of this lobsegment is 229GB. But when I select the blobs in the segment I recived only the size 145 GB.
I select with this select. Whats wrong?

select sum(dbms_lob.getlength(dokumentenblob))/1024/1024/1024 from archivblob;

Thanks.

Best regards.

roger
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 4 2011
Added on Jul 7 2011
#general-database-discussions
1 comment
198 views