SQL Question...

I'm kinda new to Oracle, so please don't kill me if this is too easy!

I have two identicle tables. each table contains a LONG column. I want to copy the data from table A to table B. Here's what I tried:

insert into B select * from A

Unfortuantely, I get a "ORA-00997: Illeage use of LONG datatype" error message.

So, how can I move the data?

Please e-mail me an answer if you would be so kind.

Thanks,

AppleLink: Allan.Marcus
CIS: 76666,2113
InterNet: allan_at_apple.com (not affiliated with Apple Computer) eWorld or NewtonMail: Allan.M
Day Job email: allan_marcus_at_lanl.gov
Day Job Voice: 505-665-1828