Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 23890 invoked from network); 11 Dec 2007 15:27:58 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by static-ip-69-64-49-119.inaddr.intergenia.de with SMTP; 11 Dec 2007 15:27:58 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E26417D7999; Tue, 11 Dec 2007 16:27:58 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 14918-08; Tue, 11 Dec 2007 16:27:58 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5CC407D7A53; Tue, 11 Dec 2007 16:27:58 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 11 Dec 2007 15:41:01 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9C26B7D80BA for ; Tue, 11 Dec 2007 15:41:01 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 06204-09 for ; Tue, 11 Dec 2007 15:41:01 -0500 (EST) Received: from cingular.com (extmail13.cingular.com [170.35.225.28]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 067057D7F07 for ; Tue, 11 Dec 2007 15:41:00 -0500 (EST) Received: from ([10.149.204.19]) by extmail13.cingular.com with ESMTP id KP-TRRF8.119815659; Tue, 11 Dec 2007 15:40:44 -0500 Received: from TBDCEXCH01.US.Cingular.Net ([10.148.7.41]) by td03xsmtp006.US.Cingular.Net with Microsoft SMTPSVC(6.0.3790.1830); Tue, 11 Dec 2007 14:40:44 -0600 X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C83C36.1A679286" Subject: RE: Logminer Question Date: Tue, 11 Dec 2007 14:40:44 -0600 Message-ID: <6A4102F59ECFA248B81F7D08F031797801F55BC0@TBDCEXCH01.US.Cingular.Net> In-Reply-To: <475C4928.7050705@att.net> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Logminer Question References: <859709.58920.qm@web58803.mail.re1.yahoo.com> <475C4928.7050705@att.net> From: "Shamsudeen, Riyaj" To: , Cc: "oracle-l" X-OriginalArrivalTime: 11 Dec 2007 20:40:44.0753 (UTC) FILETIME=[1A51D410:01C83C36] X-archive-position: 3852 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: RS2273@att.com Precedence: normal Reply-to: RS2273@att.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: Debian amavisd-new at localhost.localdomain ------_=_NextPart_001_01C83C36.1A679286 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable Sorry, if this is already answered. =20 >> but, back to my original question, am I correct that "ROLLBACK=3D1" 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. =20 ________________________________ From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Ahbaid Gaffoor Sent: Sunday, December 09, 2007 2:00 PM To: nigel_cl_thomas@yahoo.com Cc: oracle-l Subject: Re: Logminer Question =20 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...=20 but, back to my original question, am I correct that "ROLLBACK=3D1" 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 ------_=_NextPart_001_01C83C36.1A679286 Content-Type: text/html; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable

Sorry, if = this is already answered.

 

>> but, back to my original question, am I correct that = "ROLLBACK=3D1" 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@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Ahbaid Gaffoor
Sent: Sunday, December = 09, 2007 2:00 PM
To: = nigel_cl_thomas@yahoo.com
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=3D1" 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

------_=_NextPart_001_01C83C36.1A679286-- -- http://www.freelists.org/webpage/oracle-l