XPost: comp.databases.oracle.misc   
   From: fvanbortel@netscape.net   
      
   jcwhui wrote:   
   > Dale Edgar  wrote in   
   > news:tctknvg1ahvp1ga310pd1fhn1qsd90avip@4ax.com:   
   >   
   >   
   >>On Tue, 30 Sep 2003 20:55:26 GMT, jcwhui   
   >> 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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)