ORA-00997/ illegal use of LONG datatype
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: ORA-00997/ illegal use of LONG datatype

  1. #1
    Join Date
    Jan 2001
    Posts
    3,131

    Question

    create table test as select * from schema.table_name
    where 1=2;
    *
    ERROR at line 1:
    ORA-00997: illegal use of LONG datatype

    This table has a long row in it and I am trying to make a copy of it and failing miserably. Any suggestions?
    MH

  2. #2
    Join Date
    Jan 2001
    Posts
    3,131
    I managed to get the DDL from OEM and then created the table. I also used the create option in SQL*Plus's copy command, this worked too.
    MH

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