How to find concurrent transaction when we get ORA-14450
edited Jan 22, 2012 10:54PM in GoldenGate, Streams and Distributed Database (MOSC) 1 commentAnswered
According to the ORA-14450 failure description there is a concurrent transaction of the same session.
The SECOND transaction is delete on the TMP-Table according to trace file.
We're looking for the FIRST open transaction on the TMP-Table.
This transaction can't be found selecting v$lock, v$transaction, dba_2pc_pending.
How to find the FRIST transaction.
The SECOND transaction is delete on the TMP-Table according to trace file.
We're looking for the FIRST open transaction on the TMP-Table.
This transaction can't be found selecting v$lock, v$transaction, dba_2pc_pending.
How to find the FRIST transaction.
1