I took export of the Particular partition of Sales table
SQL> SELECT partition_name,NUM_ROWS FROM user_tab_partitions WHERE table_name = 'SALES';
PARTITION_NAME NUM_ROWS
------------------------------ ----------
SALES_AUG
SALES_DEV
SALES_OCT
SALES_SEP
expdp user1/user1 directory=EXPDP_DIR dumpfile=sales_table_partition.dmp tables=sales:SALES_AUG logfile=sales_table_partition.log
After that I droped that Partition
SQL> alter table SALES drop partition SALES_AUG;
Table altered.
SQL> SELECT partition_name,NUM_ROWS FROM user_tab_partitions WHERE table_name = 'SALES';
PARTITION_NAME NUM_ROWS
------------------------------ ----------
SALES_DEV
SALES_OCT
SALES_SEP
I want to restore that partition. I did import but that partition is not coming back.
impdp user1/user1 directory=EXPDP_DIR dumpfile=sales_table_partition.dmp table_exists_action = append;
SQL> SELECT partition_name,NUM_ROWS FROM user_tab_partitions WHERE table_name = 'SALES';
PARTITION_NAME NUM_ROWS
------------------------------ ----------
SALES_DEV
SALES_OCT
SALES_SEP
Suggest me how to restore that Partition