Re: BLOBs as separate tablespace

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 Wed Apr 03 2002 - 08:51:08 CST