Arup Nanda wrote a nice article about logminer, you can search otn.oracle.com, maybe this oculd help you. On 8/29/05, John Clarke <jclarke@xxxxxxxxxxxxxxx> wrote: > If you're on 9iR2+, Check out Metalink doc 291686.1. Specifically, section > 10-2. > > > > > > > hi, > > > > I need to review the contents of an archive log generated last week on > > my production database. I did some searching online but couldn't find > > anything that was very helpful - I would prefer to review the log in a > > way that has no impact on the production database. What I have found so > > far involves changing/enabling the utl_fil_dir parameter and I would > > prefer to avoid doing that. > > > > > > any help would be appreciated - thanks! > > > > > > > > > > > > > > -- > > //www.freelists.org/webpage/oracle-l > > > > > > === > John Clarke > Sr. Oracle DBA > Centroid Systems, Inc. > (248) 330-3301 > -- > //www.freelists.org/webpage/oracle-l > -- Oracle Certified Profesional 9i 10g Orace Certified Professional Developer 6i 8 years of experience in Oracle 7,8i,9i,10g and developer 6i -- //www.freelists.org/webpage/oracle-l