Re: Oracle 8.0 Copy long from 1 table to another

From: jcwhui <j_c_w_h_u_i_at_hot_mail.company>
Date: Wed, 01 Oct 2003 16:27:25 GMT
Message-ID: <Xns9407603394788jcwhui@198.161.157.145>

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? 

>
> Investigate the use of the SQLPlus COPY command. This can transfer
> longs.
>
> Here's a link to the FAQ: http://www.orafaq.com/faqplus.htm#COPYLONG
>
> Kind regards
> Dale

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

Received on Wed Oct 01 2003 - 11:27:25 CDT