ORA-00997 illegal use of long datatype
482684Aug 12 2007 — edited Aug 20 2007I have 2 tables t &t1.t has 4 coloumns and t1 has 6 columns.4 columns are common in both the tables,in that 1 column is long datatype.The requirement is to transfer the data from t to t1 table .for the long datatype it is not possible to insert the same data from t to t1.I did insert........select for the 3 common fields.how can i proceed for the long data type column?It has null values also.the other 2 columns in t1 is dummy.can any one provide me the correct solution for this case.