Re: Oracle LogMiner question

• Post for FREE via your newsreader at post.usenet.com ****

As for you first question, I am using Oracle 10G. Maybe I didn't explain what I need well... what you suggested about adding the rowid as suplementary information to the log won't help me much... this rowid is a unique identifier for a row in a table... that means that if I update this row twice I'll have the same "unique identifier" in two different redo records (the same "unique identifier" for different rows in v$logmnr_contents). The fact that I would have two records with the same identifier is not good for me. Do you have another idea?? As I said... At the beginning I thought that the SCN column at v$logmnr_contents is the unique identifier that I want, but after that, I found out that it was not unique!! what is this SCN anyway?? what does it reproduce??

Thanks,
Sami.

Howard J. Rogers wrote:

> "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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

• Usenet.com - The #1 Usenet Newsgroup Service on The Planet! *** http://www.usenet.com Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=