Re: Need to move a long column to it's own table

Have you tried moving the rest of the fields out of the table, instead of trying to move the LONG out? i.e.

create table new as select fldpk,fld2,fld3 from old;

Then drop columns from the old table as needed, and rename the new and old tables as needed. (I haven't tried it, but it should be easier and faster than trying to move the LONG around.)

> In article <934390687.24207.0.pluto.d4ee154e_at_news.demon.nl>,
> "Sybrand Bakker" <postmaster_at_sybrandb.nospam.demon.nl> wrote:
> > Hi all,
> >
> > Using Oracle 7.3.4 on NT4 sp3 at a customer, my firm designed an
> application
> > with a long column in the most-heavily used table. The average record
> length
> > is 42k, and we identified the presence of the long as the cause.
> > The solution seems to be easy: create a separate table and have the
> primary
> > key of the source table and the long there.
> > So far so good. I know this question must have been answered before,
> and I
> > did research the deja archives: how to get the data their. Create
> table as
> > select won't work, insert select won't work, etc. I rather don't want
> to
> > write an OCI program to accomplish this, and there doesn't seem to be
> a
> > solution in PL/SQL.
> >
> > Any comments...
> >
> > Thanks,
> >
> > Sybrand Bakker, Oracle DBA
Received on Fri Aug 13 1999 - 13:57:08 CDT