I believe also that you can't actually run LogMiner against an 8.0
database but have to generate the dictionary file (which you can do)
and then run the mining procedure with the dictionary file against an
8.1.x database....
- John.Hallas_at_vodafone.co.uk wrote:
> 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
> --------------------------------------------------------------------
> 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).
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: wisernet100_at_yahoo.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).
Received on Wed Jul 03 2002 - 06:13:20 CDT
