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

Thread: Import into non-partitioned table

  1. #1
    Join Date
    Sep 2000
    Location
    VA
    Posts
    343

    Import into non-partitioned table

    I have a table that has been partitioned. I need to export the data from all the partitions and import it into an unpartitioned table. Is this possible - if yes, how do I do that ?

    Thanks.

  2. #2
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    CREATE TABLE newtable AS SELECT * FROM partitioned_table;
    "What is past is PROLOGUE"

  3. #3
    Join Date
    Sep 2000
    Location
    VA
    Posts
    343
    The source and destination tables are on 2 seperate databases, so I will have to do an export/import.

  4. #4
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    1. export the table from the source database

    2. on the target database, create the table of the same structure as in the source database, however make it as nonpartitioned table here

    3. perform import of the dump from step 1) into the new table from step 2), and use IGNORE=Y while importing
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  5. #5
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    David Aldridge,
    "The Oracle Sponge"

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

    Oracle ACE

  6. #6
    Join Date
    Sep 2000
    Location
    VA
    Posts
    343
    That worked. Thanks.

  7. #7
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    Quote Originally Posted by rshivagami
    The source and destination tables are on 2 seperate databases, so I will have to do an export/import.
    Yes, there are other methods available too!

    Code:
    CREATE TABLE newtable AS SELECT * FROM partitioned_table@2nd-database;
    Still you can use this!!

    Choice is yours
    Last edited by dbasan; 09-07-2006 at 09:37 AM.
    "What is past is PROLOGUE"

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