Re: LogMiner Problem

From: <jo_holvoet_at_amis.com>
Date: Mon, 10 May 2004 12:11:12 +0200
Message-id: <OFF51E0517.75A7B926-ONC1256E90.0037E72C@eu.amis.com>

Try changing the mask for the timestamp as follows :

to_date('10-May-2004 14:22:00', 'DD-MON-YYYY HH24:MI:SS')

mvg/regards

Jo

Fahd Mirza <fahd-m_at_aero.com.pk>
Sent by: oracle-l-bounce_at_freelists.org
05/10/2004 12:05
Please respond to oracle-l  

        To:     oracle-l_at_freelists.org
        cc: 
        Subject:        LogMiner Problem

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

---

---

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:08:28 CDT