By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,501 Members | 1,861 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,501 IT Pros & Developers. It's quick & easy.

LONG RAW AND #TABLESPACE

P: n/a
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
Jul 19 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a

"M Bouloussa" <mb@asterop.com> 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
Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.