Oh, how I hate LONGs!

UNCLE! I give up!!

How the bloody h$## do I copy a LONG field from one table to another?

I'm trying to do some data archiving - moving "closed" records out of the "OLTP" section of my application to an "archive/reporting" area in another tablespace. Same database, same instance. I have some tables consisting of a primary key field (VARCHAR2(15)) and a LONG. All I want to do is copy a record from table_1 to table_1_archive.

Bloody LONG's can't appear in subqueries so I can't do a

  INSERT INTO table_1_archive
    ( pk_field_name, long_Field_name)
    SELECT pk_field_name, long_field_name     FROM table_1
    WHERE pk_field_name = 'pk value'

So how **do** I copy the darned thing????? Do I really have to write an external PRO*C program to do it (gosh I hope not!)??

(I also have to do updates but the same issues applu to UPDATE ... SELECT)

-- 
Bill Meahan  wmeahan_at_ford.com
Ford Motor Company -- End User Support - North America
Not an official statement of Ford Motor Company or anyone else
except the author.