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

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 Wed Aug 11 1999 - 11:57:56 CDT