Create Table as select * from & long datatypes - what to do?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Create Table as select * from & long datatypes - what to do?

  1. #1
    Join Date
    Aug 2000
    Location
    Alberta
    Posts
    82

    Angry

    I am trying to correct a table with a high number of chained rows, so I've
    ran the UTLCHAIN script, analyze <table> list chained rows into
    chained_rows, now I want to insert the chained rows from table_a into a temp
    table by using:

    create table table_a_chained
    as select * from table_ a
    where rownum in (select head_rownum from chained_rows
    where table_name = 'table_a')

    Then delete the rows from table_a and re-insert them from the temp table.

    unfortunatly one of the columns in table_a is a LONG RAW datatype and it
    wont allow this.


    Can I work around this?


    thanks in advance...


  2. #2
    Join Date
    Feb 2001
    Posts
    389
    use export/import but be sure of dependencies,grants and constraints.

  3. #3
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Go to SQL*Plus and use a COPY command - it supports LONGs and LONGRAWs. For exact syntax consult SQL*Plus manual.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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