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

From: Dag Arne Matre <dam_at_visma.no>
Date: Thu, 12 Aug 1999 10:07:43 +0200
Message-ID: <7otpk8$hs$1@troll.powertech.no>

I have successfully used the LANG_UPDTAB package written by Mark Lang: http://www.geocities.com/SiliconValley/Lakes/1261/ Create a view similar to the destination table and copy from the view.

D A

Sybrand Bakker wrote in message
<934390687.24207.0.pluto.d4ee154e_at_news.demon.nl>...
>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 Thu Aug 12 1999 - 03:07:43 CDT