Re: ** log miner
- From: A Joshi <ajoshi977@xxxxxxxxx>
- To: rjamya@xxxxxxxxx, Oracle Discussion List <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 22 Dec 2006 18:16:35 -0800 (PST)
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@xxxxxxxxx> 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@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?
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Other related posts:
