Exporting and import table partition data from one table to a different table in 11g
I have a table with about 52 partitions that I want to export about 20 of partitions and data to a another table in the same schema. The target table already exist without the partitions that are being imported in.
I was able to successfully export the table partitions with the following command:
expdp eta_user/********* directory=data_dump dumpfile=history_partition_2015.dmp tables=analog_history:P2015_W11,analog_history:P2015_W12,analog_history:P2015_W13,analog_history:P2015_W14,analog_history:P2015_W15,analog_history:P2015_W16,analog_history:P2015_W17,analog_history:P2015_W18,analog_history:P2015_W19 logfile=analog_history_partition.log;