Problem with with insert select from clause

Hi!

Are there any limitations to using the LONG datatype in an insert/select statement?

insert into scott.tbsql
select * from demo.tbsql where sqlid between 6117 and 6123

select * from demo.tbsql where sqlid between 6117 and 6123

       *
ORA-00997: illegal use of LONG datatype

Is there another way that I can move that data in the same table in another user's schema?

Thanks, Received on Thu Sep 14 2000 - 12:27:59 CDT