Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: BLOBs as separate tablespace

Re: BLOBs as separate tablespace

From: Yaw <yawi_at_bigpond.com>
Date: Fri, 05 Apr 2002 00:41:30 GMT
Message-ID: <_o6r8.18681$hi7.73796@news-server.bigpond.net.au> 





Hello,



I've just found out that you can avoid the entire 4K limit if you do:



insert into table values (Idnumber, EMPTY_BLOB() )



then you can stream the binary data into Oracle's BLOB, and still keep the
entire BLOB inline.  Which is pretty neat.



What do you think?  Bad idea?



Yaw.


>




> It is true that if your LOB is smaller than 4K, it can be stored in line.

> Anything larger than that, and it must be stored out of line.

Received on Thu Apr 04 2002 - 18:41:30 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US