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]

Re: LONG RAW AND #TABLESPACE


"M Bouloussa" <mb@asterop.com wrote in message
news:ab03d38.04 04210758.14ab0c d@posting.googl e.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