ODP.NET

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!

BLOB minimum size please enlighten

158283Aug 13 2003

I have tried loading 2 image file, total of 100kb but when i checked the bytes its occupied 2Mb. Is there a minimum size of a BLOB data type? This is how i checked the bytes occupied.

/* -- BEFORE LOADING -- dba_segments */

SUBSTR(SEGMENT_ BYTES INITIAL_EX NEXT_EXTEN
--------------- ---------- ---------- ----------
BLOBTEST 163840 131072 131072
BLOBTEST_IMAGE 204800 204800 204800

Image to load .. Image1.jpg -> 73kb

/* --- AFTER LOADING Image1 -- dba_segments -- */

SUBSTR(SEGMENT_ BYTES INITIAL_EX NEXT_EXTEN
--------------- ---------- ---------- ----------
BLOBTEST 163840 131072 131072
BLOBTEST_IMAGE 1433600 204800 204800

Image2.jpg -> 25kb

/* --- after loading the second image -- */

SUBSTR(SEGMENT_NAME, BYTES INITIAL_EX NEXT_EXTEN
-------------------- ---------- ---------- ----------
BLOBTEST 163840 131072 131072
BLOBTEST_IMAGE 2048000 204800 204800

Cheers,
Mon

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 10 2003

Added on Aug 13 2003

#odp-net

0 comments

324 views