-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|