What actually by default BLOB siz indicating. [merged 4 by jd] [message #554680] |
Wed, 16 May 2012 08:31 |
|
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
|
|
|
|
|
|
|
|