Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> redo stream
We got a Unique Constraint error in our application. I wanted to find
the sql which caused this. Since I found out about the error a bit after
the fact, my thoughts turned to using logminer. When thinking about this
I wondered wether the SQL which caused the error would make it to the
redo stream. If it did, the error would then need to be rolled back. But
this would need to be a special kind of rollback, one which wouldn't
terminate the transaction. So maybe the kernal would notice the error
on checking and cancel the statement before it got to the redo stream.
However, even if that happened in this case, what about ROLLBACK TO
SAVEPOINT. These statements defiinitely make the redo stream.
I'm putting together a test case, so I'll post what I find as soon as I can. (probably with other questions)
Henry
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Jun 06 2005 - 01:45:58 CDT