LONG RAW AND #TABLESPACE

[M Bouloussa]

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

[Jim Kennedy]

"M Bouloussa" <[e-mail]> wrote in message
news:ab************************@posting.google.com ...

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

Can't do that with a long raw. Why can't you use a blob? The closes you
could do is create 2 tables and the long raw table is in the other
tablespace with a key to the first. (messy. but possible) Probably could do
a view to make it look like 1 table.
Jim