There is no way to disable posting for a specific partition in a partitioned table. One needs to disable it for all partitions. The following illustrates this point:
For Ex:
SQL> select subobject_name, object_id, data_object_id, object_type from dba_objects where object_name='X_TABLE' and owner='SHA92';
SUBOBJECT_NAME OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE
------------------------------ ---------- -------------- -------------------
101137 TABLE
PART_1 101138 101138 TABLE PARTITION
PART_2 101139 101139 TABLE PARTITION
So I will need to disable posting for the complete table if the transactions on the target side are to be ignored. The value of OBJECT_ID to be disabled is 101137 and is done by setting the parameter SP_OPO_DISABLE_OBJECT_NUM on target as below (shown here for setting it globally at Post level and not at a queue level);
sp_ctrl>set param SP_OPO_DISABLE_OBJECT_NUM 101137
One can undo the above when the purpose of ignoring is over and one wants to start posting to the target table by executing the following:
sp_ctrl>reset param SP_OPO_DISABLE_OBJECT_NUM
