David,
I recall that there is a limit (42 characters?) on the name of the
dictionary file.
2 ways round it. Create the file in the top level ie /export/dict.ora or
create a symbolic link with a shorter name.
I have a page on my web site which mentions this problem
(www.hcresources.co.uk).
Unfortunately I do not (yet) have internet access at my new site and cannot
recall what exactly is on the page (I do recall it is not yet finished!!!!)
HTH
John
-----Original Message-----
Sent: 02 July 2002 19:19
To: Multiple recipients of list ORACLE-L
I tried to run LogMiner to view transactions on Oracle8.0 using LogMiner and
received following errors. Can someone please help me to fix errors. This
is HIGH priority that I am working to try to find out who messed up our
database per my Manager.
SQL> begin
2 sys.dbms_logmnr.start_logmnr(
3 DictFileName => '/export/home/oracle/LogMiner/dictionary.ora',
4 StartTime => to_date('01-Jul-2002 08:00:00AM','DD-MON-YYYY
HH:MI:SSAM'),
5 EndTime => to_date('02-Jul-2002 12:00:00AM','DD-MON-YYYY HH:MI:SSAM'));
6 end;
7 /
begin
*
ERROR at line 1:
ORA-01280: Fatal LogMiner Error.
ORA-06512: at "SYS.DBMS_LOGMNR", line 42
ORA-06512: at line 2
Thanks,
David
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nguyen, David M
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
