Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> 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.Received on Mon Jul 21 1997 - 00:00:00 CDT