Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2008

    Unanswered: copying tables with long datatype

    i try to make a copy of a table with long datatype as:
    create table new_name as select * from old_name;
    but i get an ora-00997 error that it can't copy LONG datatype columns.
    so i tried using the copy command
    copy from username/password insert into new_name using select * from old_name;
    but it says that the new_name table doesn't exists.
    does it mean i need to create it and specifying explicitly every column?

    Thank You

  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Nov 2003
    Provided Answers: 8
    If possible by any means get rid of the LONG columns and migrate to CLOB

    The LONG datatype has been deprecated since Oracle 8.2

    From the manual at
    "Do not create tables with LONG columns. Use LOB columns (CLOB, NCLOB, BLOB) instead."

Posting Permissions

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