Re: PL/SQL package help

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Mon, 18 Mar 2002 18:46:01 +1100
Message-ID: <a7460u$c1i$1@lust.ihug.co.nz>

Well, it's actually called dbmslmd.sql. But you really shouldn't need to install it by running that script: The thing should be installed by running catproc.sql. Here are the relevant lines culled from catproc.sql:

REM packages for Redo LogMiner
REM Make sure these are always called after dbmstrig.sql has been installed

@@dbmslm.sql
@@prvtlm.plb
@@dbmslmd.sql
@@prvtlmd.plb

So, the fact that you can't see those packages indicates a rather more serious problem... Try looking for them as SYS, to start with.

Regards
HJR

--
----------------------------------------------
Resources for Oracle: http://www.hjrdba.com
===============================


"rsun" <sunrui_y98_at_263.net> wrote in message
news:e44d92b1.0203172305.7972028b_at_posting.google.com...


> i had installed  oracle 8.1.6 on solaris 2.8.  now i meet a

> problem,that is I can't find DBMS_LOGMNR and   DBMS_LOGMNR_D

> package.In $ORACLE_HOME/rdbms/admin ,file  like dbmslog*.sql can't be

> founded.I don't how to install it,please help me.

Received on Mon Mar 18 2002 - 01:46:01 CST