Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Store Long raw
Longs and Long Raws are stored 'inline' with the rest of the data. Hence there is no way (that I know of, anyway) to store them separate from the rest of the data. That's one of the reasons why anyone developing a new application these days would be certifiable if they opted for Long Raws over BLOBs (BLOBs are only stored inline if they are smaller than 4K, otherwise they are automatically out-of-lined).
I guess you could use boring old relational techniques to store the Long Raw column in a separate table, linked back to the main data via one foreign key column. That's about all I can see you doing, though.
Regards
HJR
-- =============================!!============================= The views expressed are my own only, and definitely NOT those of Oracle Corporation =============================!!============================= "Roland Carlsson" <roland.c_at_swetravel.se> wrote in message news:3b2474ae$1_at_d2o21.telia.com...Received on Mon Jun 11 2001 - 02:55:07 CDT
> Hi!
> I have a table with a long raw column. I want to locate this column on
> another disk and tablespace because the files uses a lot of space. But I
can
> only find how to do with blob and (unless I'm doing something wrong) I
> doesn't work the same way???
>
> I'd appricate some suggestion where to look or even better an example of
how
> to create a table with a long raw in another tablespace.
>
> Thanks in advace
> Roland Carlsson
>
>
>