RE: LogMiner -error
- From: "Scott Canaan" <srcdco@xxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 10 Jun 2004 14:15:34 -0400
David,
You might want to try using a Unix dictionary location, not a windows
one.
Scott Canaan (srcdco@xxxxxxx)
(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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of David Boyd
Sent: Thursday, June 10, 2004 2:12 PM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxx>
>Reply-To: oracle-l@xxxxxxxxxxxxx
>To: <oracle-l@xxxxxxxxxxxxx>
>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@xxxxxxxxxxxxx
>[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of jtesta@xxxxxxxxxx
>Sent: Thursday, June 10, 2004 12:48 PM
>To: oracle-l@xxxxxxxxxxxxx
>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@xxxxxxxxxxxxx put
>'unsubscribe' in the subject line.
>--
>Archives are at //www.freelists.org/archives/oracle-l/
>FAQ is at //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@xxxxxxxxxxxxx
>put 'unsubscribe' in the subject line.
>--
>Archives are at //www.freelists.org/archives/oracle-l/
>FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
