Re: LONG RAW AND # TABLESPACE

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Thu, 22 Apr 2004 09:29:25 +1000
Message-ID: <408703d1$0$4545$afc38c87@news.optusnet.com.au>

M Bouloussa wrote:

> Hi,
>
> can you help me ?
> My problem is :
> I have two tablespaces (sdata0 and sdata1)
> On the first tablespace (sdata0) I would to store all the data except
> long raw data and on the second tablespace (sdata1) I would to store
> the long raw data
>
> This code works fine
> create table "testlob" (ID number, NAME NVARCHAR(50), BINCOL BLOB)
> tablespace sdata0
> lob(BINCOL ) store as (tablespace sdata1)
>
> BUT I can't do that when the column BINCOL is LONG RAW type
>
> (Unfortunately,I can't use BLOB instead the LONG RAW)
>
> Thank you for the help.
>
> MB

One of the key reasons for migrating to CLOBs and BLOBs is that CLOBs and BLOBs support 'out-of-line' storage (where the columns can be stored in another tablespace, as you describe in your first example). LONGs and LONG RAWs are always stored INLINE (meaning you simply can't do what you are asking to be able to do).

Either migrate to CLOBs and BLOBs, or give up trying to do what you are attempting.

Regards
HJR Received on Wed Apr 21 2004 - 18:29:25 CDT