Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle 8.0 Copy long from 1 table to another
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
-- Regards, Frank van BortelReceived on Thu Oct 02 2003 - 14:37:08 CDT