Re: Oracle 8.0 Copy long from 1 table to another

From: Frank <fvanbortel_at_netscape.net>
Date: Thu, 02 Oct 2003 21:37:08 +0200
Message-ID: <blhuc6$p0n$1_at_news1.tilbu1.nb.home.nl>

jcwhui wrote:
> 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
Insert all data, except the long, then update the long. Didn't try, but works for LOB across dblinks...

-- 
Regards, Frank van Bortel

Received on Thu Oct 02 2003 - 21:37:08 CEST