Import into non-partitioned table

[rshivagami]

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.

[dbasan]

CREATE TABLE newtable AS SELECT * FROM partitioned_table;

[rshivagami]

The source and destination tables are on 2 seperate databases, so I will have to do an export/import.

[jmodic]

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

[slimdave]

http://oraclesponge.wordpress.com/20...een-databases/

[rshivagami]

That worked. Thanks.

[dbasan]

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!

CREATE TABLE newtable AS SELECT * FROM partitioned_table@2nd-database;

Still you can use this!!

Choice is yours