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@xxxxxxxxxxx> 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


Other related posts: