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

Thread: insert into long datatype

  1. #1
    Join Date
    Jun 2000
    Location
    chennai,tamil nadu,india
    Posts
    159

    insert into long datatype

    There are 2 tables for example
    a(a number,b long raw) and b(a number,b long raw)

    i used a command to insert all the rows from b into a and i have some errors.Let me know how to resolve this.
    insert into a select * from b;
    *
    ERROR at line 1:
    ORA-00997: illegal use of LONG datatype

  2. #2
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    If you have any choice in the matter: use LOB's instead. LONG's are a pain to administer/manage and (to quote Jonathan Lewis) "You can't actually do anything with them."

    AFAIK if you're stuck with LONG, then you'll have to write PL/SQL to do the copy - presumably in 32K chunks.
    "The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman

  3. #3
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    . . . or perhaps you could:
    1) export A
    2) rename A as B
    3) import A

    but it will play merry hell with any dependencies.
    "The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman

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