ORA-00997: illegal use of a LONG datatype

I have a table psqrydefn. I used the create like statment to create a table psqrydefn2. So both tables have the same table structure. I have verified that and they do. I want to copy the data from psqrydefn to psqrydefn2. I use the statement :
insert into psqrydefn2 select * from psqrydefn;
And I get the following error message:
ORA-00997: illegal use of a LONG datatype
Could anyone help me with what I want to do? My db is 9i and it is running on a microsoft 2000 server.
Thank you.

Look at the "create table as select" (CTAS) command.

Change the LONG col to CLOB data type.

Tamil

Quote:

---

Originally Posted by jayjabour

I used the create like statment to create a table psqrydefn2.

---

What "create like" statement?

LONG columns prevent operations like INSERT ... SELECT.