Re: LogMiner Problem
- From: jo_holvoet@xxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 10 May 2004 12:11:12 +0200
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@xxxxxxxxxxx>
Sent by: oracle-l-bounce@xxxxxxxxxxxxx
05/10/2004 12:05
Please respond to oracle-l
To: oracle-l@xxxxxxxxxxxxx
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@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
-----------------------------------------------------------------
----------------------------------------------------------------
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:
