Oracle-L: RE: LogMiner errors

From: <John.Hallas_at_vodafone.co.uk>
Date: Wed, 03 Jul 2002 01:18:23 -0800
Message-ID: <F001.0048EA39.20020703011823@fatcity.com>

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: david.m.nguyen_at_xo.com

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: ListGuru_at_fatcity.com (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: John.Hallas_at_vodafone.co.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------