LogMiner -error

From: David Boyd <davidb158_at_hotmail.com>
Date: Thu, 10 Jun 2004 14:11:44 -0400
Message-ID: <BAY2-F104H6L8NakgWh0000fe7f@hotmail.com>

Hi List,

When I tried to create a dictionary file, I got following error:

ERROR at line 1:

ORA-06532: Subscript outside of limit
ORA-06512: at "SYS.DBMS_LOGMNR_D", line 783
ORA-06512: at line 1

Here is the command I created the dictionary file:

EXECUTE DBMS_LOGMNR_D.BUILD( -
DICTIONARY_FILENAME =>'dictionary.ora', - DICTIONARY_LOCATION => 'C:\oracle\log');

>From: "Jamadagni, Rajendra" <Rajendra.Jamadagni_at_espn.com>
>Reply-To: oracle-l_at_freelists.org
>To: <oracle-l_at_freelists.org>
>Subject: RE: LogMiner
>Date: Thu, 10 Jun 2004 13:03:42 -0400
>
>My previous example is for 9.2 though ... You may need to tweak some
>things to make it work on 8i.
>
>Raj
>------------------------------------------------------------------------
>--------
>Rajendra dot Jamadagni at nospamespn dot com
>All Views expressed in this email are strictly personal.
>select standard_disclaimer from company_requirements;
>QOTD: Any clod can have facts, having an opinion is an art !
>
>-----Original Message-----
>From: oracle-l-bounce_at_freelists.org
>[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of jtesta_at_dmc-it.com
>Sent: Thursday, June 10, 2004 12:48 PM
>To: oracle-l_at_freelists.org
>Subject: Re: LogMiner
>
>The docs are pretty good about logminer, the catch is with 8i,
>migrated/chained(as well as a host of other reasons) will show up as
>internal and you wont be able to see/recover those txs.
>
>joe
>
>original message below
>
>
> Hi List,
>
> We are trying to find out lost transactions from redo logs. Could any
>one please share LogMiner scripts with me? We are in Oracle 8.1.7.4
>and Sun Solaris. Thanks.
>
> David
>
>
>
>
>----------------------------------------------------------------
>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
>-----------------------------------------------------------------

---

Watch the online reality show Mixed Messages with a friend and enter to win a trip to NY
http://www.msnmessenger-download.click-url.com/go/onm00200497ave/direct/01/

---

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 Thu Jun 10 2004 - 13:08:55 CDT