insert...select... with LONG

Hi all,

Suppose I have 2 tables with same definitions, I need to do:

SQL> insert into test1b select * from test1; insert into test1b select * from test1

                          *
ERROR at line 1:
ORA-00997: illegal use of LONG datatype

How to insert into table from subquery which has LONG data type in it?

Thanx very much!

Please email me if/when possible.

-- 
Litao Wu                      
Computer Science Department    Phone: (303)543-0204
Colorado State University      Email: litao_at_cs.colostate.edu
Fort Collins, CO 80523