Re: Oracle LogMiner question

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Wed, 16 Jun 2004 20:07:31 +1000
Message-ID: <40d01bcd$0$3493$afc38c87@news.optusnet.com.au>

"Sami Zeitoun" <samizn_at_walla.co.il> wrote in message news:9a8103ea12519e0bdc1add64d67ad036$1_at_www.orafaq.net...
> **** Post for FREE via your newsreader at post.usenet.com ****
>
> Howard, thanks for answering my question.
> Actually I DO want a unique identifier for a particular single item of
> redo.. any idea how can I get that??

Ah. Well, did you mention an Oracle version? If you've got 9i Release 2 or higher, you can add supplemental logging information into the redo stream as well as the rowid (such as a row's primary key or its unique key). Would that fit the bill?

If it sounds like it might, take a look at my 9i New Features e-book at www.dizwell.com. In particular, section 3.2 on page 32 (but also bits of section 3.1).

If you don't have 9i, then you're not going to be able to do what you're after.

> As for the unique transaction id I use a combination of XIDUSN, XIDSLT,
> and XIDSQN. Do you think there is a problem with that??

Not at all... that's the techie approach I mentioned before. It's also the "correct" approach.

Regards
HJR Received on Wed Jun 16 2004 - 05:07:31 CDT