Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: ** log miner

Re: ** log miner

From: A Joshi <ajoshi977_at_yahoo.com>
Date: Fri, 22 Dec 2006 18:16:35 -0800 (PST)
Message-ID: <251789.75619.qm@web58007.mail.re3.yahoo.com>


Thanks rjamya.    

  That worked. for some of where seg_name = 'EPML' I am still getting some sql_redo as :    

  Unsupported    

  For others I am seeing the sql statements like 'update EPML....'    

  Thanks

rjamya <rjamya_at_gmail.com> wrote:

    you can use online dict, but try specifying full path for the file when you do add_file, then start the logminer.    

  use (since you have only one file)    

  dbms_logmnr.add_file('file/with/full/path/',dbms_logmnr.new);   dbms_logmnr.start_logmnr(options=>dbms_logmnr.DICT_FROM_ONLINE_CATALOG);    

  this is from memory, check the syntax. but if you are using on-line catlog, there is no need to specify dictfile.   rjamya  

  On 12/22/06, A Joshi <ajoshi977_at_yahoo.com> wrote:     Hi,
     I am using log miner on 9.2.06. With DICT_FROM_ONLINE_CATALOG option since UTL_FILE is not set for flat file option. After start_logmnr what happens is it works for select sql_redo from V$LOGMNR_CONTENTS
where rownum < 3 which returns 'commit', 'set transaction..' but if I give where rownum < 10 it just kicks out the session. Same if I use where seg_name = 'EPML'.   Is there any setting I need to do. I only added one logfile. I think it is erroring when it has to convert to actual table/column names using the dictionary. Thanks for help. I am doing :   EXECUTE sys.DBMS_LOGMNR.START_LOGMNR (-  DICTFILENAME =>sys.DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG)  

  or
  EXECUTE sys.DBMS_LOGMNR.START_LOGMNR (-  DICTFILENAME =>sys.DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG, -   options => sys.DBMS_LOGMNR.new)  



Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

--



Got RAC?

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
--

http://www.freelists.org/webpage/oracle-l Received on Fri Dec 22 2006 - 20:16:35 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US