XPost: comp.databases.oracle.misc   
   From: j_c_w_h_u_i@hot_mail.company   
      
   Hello all,   
      
   Yes, it is another Oracle 8.0 question.  We are just too small to force our   
   customer to migrate to newer Oracle.   
      
   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?   
      
   Thanks in advance!!!   
      
      
   - Will   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)