Inserting Data Into Long Data Type

Dear all,

I have a problem when inserting data with LONG datatype, from another table with long datatype too.
Ex:
 Table A (X1 Long)
 Table B (X2 Long)

I want to insert into table A from table B:   insert into A (X1)
  select X2 from B

When I do this, i've got an error message :   ORA-00997: illegal use of LONG datatype

How do I solve this problem ?
I guess the problem will occur on RAW datatype too.

Thanks.

Kuncoro
Jakarta, Indonesia Received on Thu Sep 02 1999 - 01:56:55 CDT