Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Logminer Question
What's puzzling is the developer is claiming that no ORA- errors were
seen, so even with a PK or unique key violation that should throw an error.
Does Oracle actually apply the transaction then roll it back in cases of PK/Unique viloations?
Interesting, I'll test for that
thanks!
Ahbaid
Finn Jorgensen wrote:
> Barring a user rollback operation, perhaps an insert into a table with
> a PK or unique index which was violated?
>
> Finn
>
> On Dec 8, 2007 2:59 PM, Ahbaid Gaffoor <ahbaid_at_att.net
> <mailto:ahbaid_at_att.net>> wrote:
>
> We're trying to figure out exactly what an application has done in the
> db. I restored an archive log from tape and mined it.
>
> When querying the logminer view I'm seeing two rows for a
> transaction in
> V$LOGMNR_CONTENTS
>
> The first row has sql entries in SQL_REDO and SQL_UNDO, and the
> ROLLBACK
> field is 0
>
> The second row has sql only in SQL_REDO and the ROLLBACK field is 1
>
> Both rows have the same SCN and TIMESTAMP, does this mean that the
> first
> row was applied and the second was indeed a rollback entry?
>
> What's especially puzzling is we are not seeing any lost
> connections or
> abnormal program terminations, so what's causing this rollback entry?
>
> all ideas and comments welcome.
>
> thanks
>
> Ahbaid
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Sun Dec 09 2007 - 00:18:48 CST
![]() |
![]() |