-
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.
-
CREATE TABLE newtable AS SELECT * FROM partitioned_table;
"What is past is PROLOGUE"
-
The source and destination tables are on 2 seperate databases, so I will have to do an export/import.
-
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?
-
-
-
 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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|