Re: BLOBs as separate tablespace

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Wed, 3 Apr 2002 12:46:57 +0100
Message-ID: <3caaebb2$0$236$ed9e5944@reading.news.pipex.net>

you can create your table like so

create table t(id number,bincol Blob)
tablespace users
lob(bincol) store as (tablespace lob_data pctversion 0)

which will store normal data in the users tablespace and lob data in a dedicated lob tablespace. PCTVersion refers to the how much of the lob segment is dedicated to storing old versions of the lob (for read consistency reasons). 0 seems to me appropriate for lobs that are juzt stored and never updated (though they could be deleted and inserted).

--
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:YDBq8.15053$hi7.55180_at_news-server.bigpond.net.au...


> Hi,

>

> I know I've already posted to the other newsgroup, I just forgot to also

> post to this newsgroup at the same time.  But...

>

>

> I just like to confirm the process of creating BLOBs in Oracle.

>

> That I need to create a new tablespace to place the table with the BLOB,

> when I create BLOBS which are larger than a certain size ( I think it's

4k).


>

> Or can I simply just create tables with BLOB types and not worry about the

> need to create a new tablespace?

>

> Thanks in advance.

>

> Yaw.

>

>

Received on Wed Apr 03 2002 - 05:46:57 CST