I have Oracle (Intelligent) running - 4.1.1 with wM Ent Broker 5.0.1. I configured an insert notification operation to select all the columns when 2 of the columns (say A and B) are not null. I notice that the buffer table that oracle adapter automatically created behind the scene is populated everytime a new row is inserted regardless of whether or not the column A and B are Null or not null. Then the rows with A and B not null will then get published. However the rows that didn’t meet the condition stays in the buffer table.
My question is when will those rows get deleted? Will they ever get deleted?