Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Oracle 8.0 Copy long from 1 table to another
Hello all,
Yes, it is another Oracle 8.0 question. We are just too small to force our customer to migrate to newer Oracle.
My problem is I need to copy the value of the long column in table A to another table B's long column.
Unfortunately, "insert into table_a select long_column from table_b" doesn't work. I also thought of changing table_a's long column to clob, and convert table_b.long_column to clob before inserting into table_a, but to_lob() doesn't exist in Oracle 8.0.
So is this my only option: dumping table_b.long_column to a file and loading it back to table_a.long_column?
Thanks in advance!!!