Moving a LONG

I have created the following table

create table test01 (
theText LONG
)

I have another table (test01) that has a column (oldText) defined as LONG that I would like to move/copy into this new table (test01).

I have tired

insert into test01
(theText)
select oldText from test01

I receive the following error:

ORA-00997: illegal use of LONG datatype

Okay, so how does one move around a LONG?

Any thoughts would be greatly appreciated.

Thanks.

Tal Golan
talgolan_at_optic-nerve.com Received on Mon Nov 09 1998 - 13:28:38 CST