-
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
-
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.
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
|