LogMiner Problem
- From: "Fahd Mirza" <fahd-m@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 10 May 2004 15:05:40 +0500
Hi,
I want to mine the logs between the timings of 11:30 am to 2:22 pm.
When I execute the below given statement, I get error that date range
specified is incorrect.
EXECUTE DBMS_LOGMNR.START_LOGMNR(DICTFILENAME =>
'c:/oracle/logs/dictionary.ora',STARTTIME => to_date('10-May-2004 11:30:00',
'DD-MON-YYYY HH:MI:SS'),ENDTIME => to_date('10-May-2004 2:22:00', 'DD-MON-YYYY
HH:MI:SS'));
I am sure that logminer is taking the endtime to the next date "(i.e. in 11th
May).
When I write the above statement like this
EXECUTE DBMS_LOGMNR.START_LOGMNR(DICTFILENAME =>
'c:/oracle/logs/dictionary.ora',STARTTIME => to_date('10-May-2004 11:30:00',
'DD-MON-YYYY HH:MI:SS'),ENDTIME => to_date('10-May-2004 14:22:00', 'DD-MON-YYYY
HH:MI:SS'));
I get the error that hour must be between 1 and 12.
Please help me, thanks.
regards,
Fahd
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
