Poster: ORA-02149: Specified partition does not exist and unusable indexes after drop and truncate of partitions. (4345260)

1. Post fails with error ORA-02149 when table partition is dropped and truncated.

2. Also find unusable Global indexes in database alert log when table partition is dropped and truncated.

Error Details: 

Table partitions are managed by Oracle so partition IDs will be different between the Source and Target databases.
If we truncate or drop the partitions Post will face this issue.
And also performing drop and truncate of partitions causes index unusable.
 

To fix Poster: ORA-02149 issue we need to set SP_OCT_TRUNC_PARTITION_BY_ID  to 1 and this is a live parameter so it will take effect immediately.
Also, to fix the unusable indexes if you are using both drop and truncate of partition, you first need to use truncate and then drop of partitions - follow below steps:

1. alter table <table_name> truncate partition <partition_name> update global indexes PARALLEL 32;
2. alter table <table_name> drop partition <partition_name> update global indexes PARALLEL 32;