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.