Howard has pointed out the in-line storage of 'small' LOBs which I did not
address. I'd only add the caveat that if the lobs are in fact character
based and under 4k in size I'd be sorely tempted to replace them with a
varchar2(4000) datatype.
Others might have different ideas, but my opinion (though I must confess not
always reflected in our practice) is that LOB datatypes really do belong in
their own tablespace (or out of the database altogether as a BFILE) even
though the default behaviour is not to put them there.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Yaw" <yawi_at_bigpond.com> wrote in message
news:wFEq8.15428$hi7.58159_at_news-server.bigpond.net.au...
> Thanks for your replies. :) They're really good. :)
>
> All this time I was labouring under the belief that in order to create
BLOBs
> in tables the BLOBs themselves "must" be stored in anther tablespace if
they
> were larget than 4K (I think).
>
> From your reply, it seems that I was wrong.
>
> Yaw.
>
>
> "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message
> news:3cab0bfc$0$8514$ed9e5944_at_reading.news.pipex.net...
> > sorry came in late.
> >
> > Yes using my example you do need two pre existing tablespaces. The
> rationale
> > for my approach is to seperate out the blob data from the bog standard
> > relational data. If you don't use the store as clause the lob segments
> will
> > get stored in tablespace USERS on my example. if you don't specify any
> > tablespace clause the whole lot will get stored in the creating users
> > default tablespace, and if you don't specify a storage clause for the
> table
> > you like as not have not specified a default storage clause for the user
> so
> > everything will end up in the SYSTEM tablespace.
> >
> > Or in other words lobs get stored
> >
> > in the tablespace specified in the store as clause of create table or if
> > this isn't specified
> > in the tablespace specified in the create table statement or if there
> isn't
> > one specified
> > in the creating users default tablespace. (as does the table).
>
>
>
Received on Thu Apr 04 2002 - 02:11:28 CST
