Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: LONG RAW AND # TABLESPACE
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
You have encountered one of the many limitations of RAW. No way around it if you insist on staying with RAW.
Oracle has clearly stated that the RAW should be avoided. This is one of the many reasons.
Why can you not switch? (Next question will be: Why do you trust those who are forcing you to stay with obsolete and inefficient technology?)
/Hans Received on Wed Apr 21 2004 - 11:12:51 CDT