Datapump import partitions
Hi,
I have both source and target databases are running on 11.2.0.3. In the source database, I have a table called EMPDATA with partition part_jan, part_feb, part_mar, part_apr, part_may, and part_june.
In target database I have the same table name (EMPDATA) with partition part_jan, part_feb, and part_mar. Now I want to export partitions part_apr, part_may and part_june from source to target database.
I know if i used datapump export table_exist_action with append the partitions will not be created in target database table, I would want to import those data together with partitions created.