Re: Oracle 8.0 Copy long from 1 table to another

Dale Edgar <Dale_at_DataBee.com> wrote in news:tctknvg1ahvp1ga310pd1fhn1qsd90avip_at_4ax.com:

> On Tue, 30 Sep 2003 20:55:26 GMT, jcwhui
> <j_c_w_h_u_i_at_hot_mail.company> wrote:
>

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

I doubt this will work for me. My code is inside a stored procedure. And in fact I meant to copy 1 particular row from table_b to table_a, i.e. "insert into table_a select long_column from table_b where id=123"

I guess external file access is my only option now. Thanks anyway!

• Will