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

From: AleX <korrozia_at_my-deja.com>
Date: Wed, 11 Aug 1999 22:03:25 GMT
Message-ID: <7osrv8$t63$1@nnrp1.deja.com>

I'd dump the data in the table into 2 flat files (one without the long column, and one with just the long column) and use sqlloader to import the files into their respective tables.

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
>
>

--

                 Alex Shterenberg

"I hate people. I think they should suffer as much as  possible, and therefore I'm into those old communist

         dictatorships." - Euronymous, Mayhem

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Aug 11 1999 - 17:03:25 CDT