What actually by default BLOB siz indicating. [merged 4 by jd] [message #554680] |
Wed, 16 May 2012 08:31 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/0131d57de01ec674a25542137cd1261a?s=64&d=mm&r=g) |
samiran_cts
Messages: 52 Registered: January 2012
|
Member |
|
|
CREATE TABLE test_lob (
id NUMBER
, file_name VARCHAR2(45)
, image BLOB
, timestamp DATE
);
SELECT table_name, column_name, segment_name, a.bytes
FROM dba_segments a JOIN dba_lobs b
USING (owner, segment_name)
where B.TABLE_NAME = 'TEST_LOB';
[The output it is showing 65536 bytes for column image although no data is inserted in the table. What actually this size signify. Is it Blob locater]
Thanks in advance!
Samiran
[EDITED by LF: fixed [code] tags]
[Updated on: Fri, 18 May 2012 00:11] by Moderator Report message to a moderator
|
|
|
|
|
|
|
|