Re: BLOBs as separate tablespace

From: Yaw <yawi_at_bigpond.com>
Date: Wed, 03 Apr 2002 12:38:16 GMT
Message-ID: <YICq8.15263$hi7.56526@news-server.bigpond.net.au>

> 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).

Thanks, I'm a however, just a little confused. Does that mean that there must exist already two tablespaces? One for the normal tables, and another where the LOBs will be stored?

Using your example: we'll need to have a tablespace where the table 't' is stored. And also another tablespace 'lob_data', where the LOB data will be stored.

TIA.
Yaw. Received on Wed Apr 03 2002 - 06:38:16 CST