Re: Logminer Question

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> 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-l