Oracle 8.0 Copy long from 1 table to another

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!!!

• Will