Using Logminer

From: <64.14.6.99>
Date: 26 Jun 2001 02:13:22 GMT
Message-ID: <9h8r426254@enews1.newsguy.com>

Hello,

I am trying to run logminer on my oracle database 8.1.6, but am getting some errors. Am following following steps -

Add a variable in D:\Oracle\Admin\<database>\pfile\init.ora for UTL_FILE_DIR
Execute D:\Oracle\Ora81\RDBMS\Admin\dbmslm.sql - runs successfully.
Execute D:\Oracle\Ora81\RDBMS\Admin\dbmslmd.sql - gives following error -

<<<<<<<<<<<<<<<<<<<Error Begin>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Package created.

Warning: Package Body created with compilation errors.

Errors for PACKAGE BODY DBMS_LOGMNR_D:

LINE/COL ERROR

-------- -----------------------------------------------------------------
173/7    PL/SQL: SQL Statement ignored
175/15   PLS-00201: identifier 'SYS.V$COMPATIBILITY' must be declared
178/7    PL/SQL: SQL Statement ignored
184/16   PLS-00201: identifier 'SYS.V$DATABASE' must be declared
193/7    PL/SQL: SQL Statement ignored
193/42   PLS-00201: identifier 'SYS.OBJ$' must be declared

268/3 PL/SQL: SQL Statement ignored
268/14 PLS-00320: the declaration of the type of this expression is

incomplete or malformed

287/8 PLS-00201: identifier 'SYS.COL$' must be declared

LINE/COL ERROR

-------- -----------------------------------------------------------------
303/5    PL/SQL: SQL Statement ignored

693/1 PL/SQL: SQL Statement ignored
693/38 PLS-00201: identifier 'SYS.V_$PARAMETER' must be declared

Grant succeeded.
<<<<<<<<<<<<<<<<<<<Error End>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Any idea why is this happenning? Thanks for your help.

Regards,
Sumitabh

Poster's IP address: 64.14.6.99
Posted via http://nodevice.com
Linux Programmer's Site Received on Mon Jun 25 2001 - 21:13:22 CDT