Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> LONG RAW AND # TABLESPACE

LONG RAW AND # TABLESPACE

From: M Bouloussa <mb_at_asterop.com>
Date: 21 Apr 2004 08:59:44 -0700
Message-ID: <ab03d38.0404210759.1b1105e9@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 Received on Wed Apr 21 2004 - 10:59:44 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US