DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: ORA-00997: illegal use of a LONG datatype

  1. #1
    Join Date
    Mar 2005
    Posts
    143

    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.

  2. #2
    Join Date
    Jun 2006
    Posts
    259
    Look at the "create table as select" (CTAS) command.

  3. #3
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Change the LONG col to CLOB data type.

    Tamil

  4. #4
    Join Date
    Jun 2005
    Location
    London, UK
    Posts
    159
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width