LOG MINER

[svk]

Its kind of a BUG !!

What you need to do is, edit the dbmslmd.sql script and change the variable declaration of 'col_desc_array' from varray(513) to varray(700). And then, execute this script to recreate the package.

More explanation on Metalink...

[cravi]

Hi Jeff & SVK

Thanks alot for your help and time friends. As you guys adviced i changed col_desc_array from 513 to 700 and the dictionary file was created successfully.

I am going to further explore into the log miner and will contact you for the same if i end up with any new problems.

Thanks much once again
Ravi

[cravi]

Hi

I am trying to declare the log files to be monitored by DBMS_LOGMNR. I am getting an error message like:

SQL> begin
2 DBMS_LOGMNR.ADD_LOGFILE(
3 logfilename => 'C:\programfiles\Ora81\oradata\test\archive\[TEST]1_496.ARC',
4 options => dbms_logmnr.NEW);
5 END;
6 /
options => dbms_logmnr.NEW);
*
ERROR at line 4:
ORA-06550: line 4, column 24:
PLS-00302: component 'NEW' must be declared
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored


SQL> begin
2 DBMS_LOGMNR.ADD_LOGFILE(
3 logfilename => 'C:\programfiles\Ora81\oradata\test\archive\[TEST]1_496.ARC',
4 options => dbms_logmnr.ADDFILE);
5 END;
6 /
options => dbms_logmnr.ADDFILE);
*
ERROR at line 4:
ORA-06550: line 4, column 24:
PLS-00302: component 'ADDFILE' must be declared
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored

Can you correct me please!!

Thanks
Ravi

[cravi]

ORA-06550: line num, column num: str
Cause: A PL/SQL compilation error has occurred. The numbers given for line and column are the location in the PL/SQL block where the error occurred.

Action: Refer to the following PL/SQL messages for more information about the error.

[pando]

can you stop repeating your post?

[cravi]

Hey Pando

Its a mistake. Sorry for the Inconvenience.