Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

lohminer error

737288Nov 26 2009 — edited Feb 19 2010
help me i execute this commond

SQL> execute dbms_logmnr.start_logmnr(dictfilename =>'/u02/oradata/lgmnr/TSH1dict.ora',-
starttime => to_date('2009-07-19','yyyy-mm-dd hh24:mi:ss'),endtime => to_date('2009-08-27 -
08:12:37','yyyy-mm-dd hh24:mi:ss'));

after execute above commona query get this error please solve it logminer error

BEGIN dbms_logmnr.start_logmnr(dictfilename =>'/u02/oradata/lgmnr/TSH1dict.ora',
starttime => to_date('2009-07-19','yyyy-mm-dd hh24:mi:ss'),endtime => to_date('2
009-08-27 08:12:37','yyyy-mm-dd hh24:mi:ss')); END;

*
ERROR at line 1:
ORA-01292: no log file has been specified for the current LogMiner session
ORA-06512: at "SYS.DBMS_LOGMNR", line 42
ORA-06512: at line 1




thanks best regard

kashif ahmed
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 19 2010
Added on Nov 26 2009
4 comments
1,965 views