+ Reply to Thread
Results 1 to 2 of 2
  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

Bookmarks

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