RE: LogMiner -error

From: Scott Canaan <srcdco_at_rit.edu>
Date: Thu, 10 Jun 2004 14:15:34 -0400
Message-ID: <D0A642D37DE30842AA667A9AFFE3951A964419@mapi-server.test.rit.edu>

David,

   You might want to try using a Unix dictionary location, not a windows one.

Scott Canaan (srcdco_at_rit.edu)
(585) 475-7886
"Life is like a sewer, what you get out of it depends on what you put into it." - Tom Lehrer.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of David Boyd Sent: Thursday, June 10, 2004 2:12 PM
To: oracle-l_at_freelists.org
Subject: LogMiner -error

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
-----------------------------------------------------------------
----------------------------------------------------------------
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:12:31 CDT