Hi,
The following scenario is just my assumption, what could have happened in a certain case.
There was a record modification in table1, and the entire record was written to table2 (new record created). Some error must have occurred, because the modification in table1 has been rolled back, but it seems only after 30 minutes or so.
Question1: is it possible that a transaction will be rolled back not immediately, without any dba intervention?
Question2: Let's suppose the transaction rollback is pending in table2 (record creation), when another program tries to delete the newly created record. I assume the deletion has to wait until the rollback is pending, after it has been completed, deletion can be performed (since record creation has been cancelled). Is this logic correct?
Thanks in advance,
Peter
The following scenario is just my assumption, what could have happened in a certain case.
There was a record modification in table1, and the entire record was written to table2 (new record created). Some error must have occurred, because the modification in table1 has been rolled back, but it seems only after 30 minutes or so.
Question1: is it possible that a transaction will be rolled back not immediately, without any dba intervention?
Question2: Let's suppose the transaction rollback is pending in table2 (record creation), when another program tries to delete the newly created record. I assume the deletion has to wait until the rollback is pending, after it has been completed, deletion can be performed (since record creation has been cancelled). Is this logic correct?
Thanks in advance,
Peter