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!

Basic doubt on BLOB/CLOB

576656Jul 19 2007 — edited Jul 19 2007

In Oracle 10g, the max size for BLOB/CLOB is mentioned as 4GB.

If i store a binary file of size 2MB in a BLOB field, will it block the whole 4GB (4096MB) space for this. Or as like Varchar only the actual file size is used and leave the remaining 4094 MB as free.

Please clarify.

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 16 2007

Added on Jul 19 2007

#general-database-discussions

5 comments

381 views