Home » RDBMS Server » Server Administration » What actually by default BLOB siz indicating. [merged 4 by jd] (oracle 10g)
What actually by default BLOB siz indicating. [merged 4 by jd] [message #554680] Wed, 16 May 2012 08:31 Go to next message
samiran_cts
Messages: 49
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

Re: What actually by default BLOB siz indicating. [message #554683 is a reply to message #554680] Wed, 16 May 2012 08:41 Go to previous messageGo to next message
BlackSwan
Messages: 26763
Registered: January 2009
Location: SoCal
Senior Member
size depends upon additional details

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/
Re: What actually by default BLOB siz indicating. [merged 4 by jd] [message #554826 is a reply to message #554680] Thu, 17 May 2012 12:49 Go to previous messageGo to next message
Michel Cadot
Messages: 67810
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
When you create a physical object it has a minimum size even if there is nothing inside it.

Regards
Michel
Re: What actually by default BLOB siz indicating. [merged 4 by jd] [message #554846 is a reply to message #554826] Thu, 17 May 2012 21:04 Go to previous messageGo to next message
samiran_cts
Messages: 49
Registered: January 2012
Member
IS it the size of LOB locator or something else.
Re: What actually by default BLOB siz indicating. [merged 4 by jd] [message #554847 is a reply to message #554846] Thu, 17 May 2012 21:17 Go to previous messageGo to next message
BlackSwan
Messages: 26763
Registered: January 2009
Location: SoCal
Senior Member
>IS it the size of LOB locator or something else.
yes
a well composed SQL statement can provide answer to question above
Re: What actually by default BLOB siz indicating. [merged 4 by jd] [message #554854 is a reply to message #554846] Fri, 18 May 2012 00:35 Go to previous message
Michel Cadot
Messages: 67810
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
samiran_cts wrote on Fri, 18 May 2012 04:04
IS it the size of LOB locator or something else.


else: nothing, free space (and Oracle segment header).

Regards
Michel

Previous Topic: To write Bangla Language in Oracle 10gR1 , 10gR2 and Express .(2 Merged)
Next Topic: Oracle 10g server went in hanging condition
Goto Forum:
  


Current Time: Wed Apr 14 17:05:02 CDT 2021