import to different table name ?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: import to different table name ?

  1. #1
    Join Date
    Mar 2001
    Posts
    16

    import to different table name ?

    is there a way to import a table to a different table name ?

  2. #2
    Join Date
    Jan 2001
    Posts
    3,131
    Not that I know of, you can do a..
    SQL>insert into as select from

    Or just re-name the table after import, no?

    MH
    I remember when this place was cool.

  3. #3
    Join Date
    Mar 2001
    Posts
    16
    no, i was hoping that there's a command out there that would let you specify something like
    FROM table TO table...

  4. #4
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    If you exported a table OLD_TABLE and wanted to import it as NEW_TABLE, then you might try pre-creating NEW_TABLE, then putting a view on it as ...

    CREATE VIEW OLD_TABLE AS SELECT * FROM NEW_TABLE

    ... and running a conventional path import, making sure to set it to ignore errors on import.

    This sort of thing can also work for importing into a table having a different column list.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  5. #5
    Join Date
    May 2002
    Location
    USA
    Posts
    462
    can i know if there is any specific reason for not using

    insert into table as select ....
    or
    renaming a table after insert .
    siva prakash
    DBA

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