LogMiner Problem

From: Fahd Mirza <fahd-m_at_aero.com.pk>
Date: Mon, 10 May 2004 15:05:40 +0500
Message-ID: <079e01c43676$5958a900$a00100ac@awc.com>

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_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Mon May 10 2004 - 05:02:06 CDT