Re: Logminer

From: Lyubomir Petrov <lpetrov_at_yahoo.com>
Date: Mon, 18 Mar 2002 09:24:44 -0800
Message-ID: <F001.0042C1E4.20020318092444@fatcity.com>

Hi John,

You did not mention the Oracle version, but I hope this will help.

In $ORACLE_HOME/rdbms/admin/dbmslmd.sql (the script that builds DBMS_LOGMNR_D package) there is a line:

TYPE col_desc_array IS VARRAY(513) OF col_description;

Replace it with something like:

TYPE col_desc_array IS VARRAY(1000) OF
col_description;

and then rebuild the package.

HTH,
Lyubomir Petrov

• John Dunn <john.dunn_at_sefas.co.uk> wrote:
  > I get the following error when running
  > SYS.DBMS_LOGMNR_D
  >
  > ERROR at line 1:
  > ORA-06532: Subscript outside of limit
  > ORA-06512: at "SYS.DBMS_LOGMNR_D", line 793
  > ORA-06512: at line 1
  >
  > Anyone else seen this?
  >
  > John
  >
  > --
  > Please see the official ORACLE-L FAQ:
  > http://www.orafaq.com
  > --
  > Author: John Dunn
  > INET: john.dunn_at_sefas.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!?
Yahoo! Sports - live college hoops coverage http://sports.yahoo.com/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Lyubomir Petrov
  INET: lpetrov_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 Mon Mar 18 2002 - 11:24:44 CST