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

Thread: Import into non-partitioned table

Threaded View

  1. 09-07-2006, 09:33 AM #5
    dbasan's Avatar
    dbasan
    dbasan is offline Advisor
    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"
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width