I have a streams apply process that has triggers on the target tables. The triggers fire after the target table is update and update a secondary set of tables.
Once in a while we have a deadlock during the firing of the triggers that update the secondary set of tables and Oracle resolves the deadlock by rolling back the transaction that identified the deadlock. Because the triggers fire to update the secondary tables the session that is identified to be in error in the apply process.
My question is this: how does the rollback affect streams ? I don't get an error... Is the entire transaction rolled back and therefore the row removed from the target table (table with the triggers) ? Would streams know about this rollback?
Oracle 12.1.0.2 on solaris