Re: logMiner

From: David Boyd <davidb158_at_hotmail.com>
Date: Tue, 29 Aug 2006 10:23:15 -0400
Message-ID: <BAY101-F288FBCA311DA60B491BB6BEF390@phx.gbl>

Raj,

Thanks. The issue has been resolved.

Dave

>From: rjamya <rjamya_at_gmail.com>
>Reply-To: rjamya_at_gmail.com
>To: davidb158_at_hotmail.com
>CC: oracle-l_at_freelists.org
>Subject: Re: logMiner
>Date: Tue, 29 Aug 2006 10:05:03 -0400
>
>I usually do
>
>create table my_logminer as select * from v$logmnr_contents;
>
>and then take it from there. usually it involvs writing a plsql loop
>to reconstruct really long sql statements.
>
>Raj
>
>On 8/29/06, David Boyd <davidb158_at_hotmail.com> wrote:
>>Hi List,
>>
>>We had system time flipped back for a short time frame. Now we're trying
>>to
>>correct the some data. We pulled out transactions from redo log. But the
>>output in sql_redo and sql_undo columns is not readable. I was wondering
>>if
>>there is any way to reconstruct the output. We tried using
>>print_pretty_sql. However the output is the same.
>>
>>We are in Oracle 9.2.0.6.
>>
>>Dave
>>
>>_________________________________________________________________
>>Windows Live Spaces is here! It's easy to create your own personal Web
>>site.
>> http://spaces.live.com/signup.aspx
>>
>>--
>>http://www.freelists.org/webpage/oracle-l
>>
>>
>>
>
>
>--
>----------------------------------------------
>Got RAC?
>--
>http://www.freelists.org/webpage/oracle-l
>
>

---

Search from any web page with powerful protection. Get the FREE Windows Live Toolbar Today! http://get.live.com/toolbar/overview

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Aug 29 2006 - 09:23:15 CDT