import a table's data within same schema to different table
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: import a table's data within same schema to different table

  1. #1
    Join Date
    Sep 2005
    Location
    Delhi
    Posts
    78

    import a table's data within same schema to different table

    Hi

    How can i import a table from an export file with different name within same schema.
    e.g i have a table a1 in user1 schema and have exported this table only.
    now i want to import this table as a2 with same schema user1
    ~KD.DBA~

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Code:
    create table a2 as select * from a1;
    Is it what you want?
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  3. #3
    Join Date
    Sep 2005
    Location
    Delhi
    Posts
    78
    Quote Originally Posted by SANJAY_G
    Code:
    create table a2 as select * from a1;
    Is it what you want?
    I know this. but can i do same from imp utility.
    ~KD.DBA~

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    no, you cant rename tables

  5. #5
    Join Date
    Nov 2001
    Posts
    335
    export your table first, rename table to table_old, import table back, rename imported table to table_new, rename table_old to table.
    One, who thinks that the other one who thinks that know and does not know, does not know either!

  6. #6
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Quote Originally Posted by BV1963
    export your table first, rename table to table_old, import table back, rename imported table to table_new, rename table_old to table.
    Wondering why someone would want to do this.
    and not 'create table as select'.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its 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