Re: logMiner

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