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.
Printable View
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;
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
That worked. Thanks.
Yes, there are other methods available too!Quote:
Originally Posted by rshivagami
Still you can use this!!Code:CREATE TABLE newtable AS SELECT * FROM partitioned_table@2nd-database;
Choice is yours :D