RE: Logminer Question
- From: "Shamsudeen, Riyaj" <RS2273@xxxxxxx>
- To: <ahbaid@xxxxxxx>, <nigel_cl_thomas@xxxxxxxxx>
- Date: Tue, 11 Dec 2007 14:40:44 -0600
Sorry, if this is already answered.
>> but, back to my original question, am I correct that "ROLLBACK=1"
indicates that this transaction was applied to rollback a row?
Yes. That's correct. But, there may be more than one redo record per
row, for dependent objects (such as index) etc.
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Ahbaid Gaffoor
Sent: Sunday, December 09, 2007 2:00 PM
To: nigel_cl_thomas@xxxxxxxxx
Cc: oracle-l
Subject: Re: Logminer Question
Hello Nigel,
there are no deferred constraints, actually the design is so bad that
there are very few constraints.
I'm beginning to want to take the app from the developer and start going
through it with a fine tooth comb. This is perhaps the best approach to
see what's going wrong.
The problem I am faced with is the developer is claiming "Oracle is
doing something" :)
I think I need to tear the app apart...
but, back to my original question, am I correct that "ROLLBACK=1"
indicates that this transaction was applied to rollback a row?
Also, how do you order entries in V$LOGMNR_CONTENTS if they have the
same SCN and TIMESTAMP?
many thanks
Ahbaid
Other related posts:
