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@xxxxxxxxx> 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?