Re: Store Long raw

You can move the tablespace that the table containing the LONG RAW is in using the steps I've just outlined in a reply on the "Oracle System Tables" thread. Unless I'm mistaken, LONG RAW has been around since Oracle7. The LOB types came after, and are more robust in every sense than the LONG types. I tell people not to use the LONGs and if you inherit a database that has them, update them to LOBs as soon as you can. Whether you follow Howard's suggestion and split the table or convert to a LOB, if you have lots of code supporting the LONG RAW column you've got some work ahead of you.

To convert a LONG RAW to a LOB column you have to copy the table like so:

CRATE TABLE new_table AS
SELECT col1, col1, ..., TO_LOB(long_raw_col)

Best!

Randall

Roland Carlsson <roland.c_at_swetravel.se> wrote in message news:3b2474ae$1_at_d2o21.telia.com...
> 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
>
>
>
Received on Mon Jun 11 2001 - 10:00:43 CDT