Archivelog

[krw]

Hi all,

Database: 8.1.7.4
Sun Solaris OS

Is there a way to read the contents of an archivelog?

Regards

[julian]

YES. With Logminer.

[krw]

When running the dbms_logmnr_d.build I'm getting the below error:

ERROR at line 1:
ORA-06532: Subscript outside of limit
ORA-06512: at "SYS.DBMS_LOGMNR_D", line 793
ORA-06512: at line 1


Any help?

[julian]

Originally posted by krw
When running the dbms_logmnr_d.build I'm getting the below error:

ERROR at line 1:
ORA-06532: Subscript outside of limit
ORA-06512: at "SYS.DBMS_LOGMNR_D", line 793
ORA-06512: at line 1


Any help?

Wow, you learn quickly :-) Took you few minutes to start setting up LOGMINER.

From Metalink:

1. Edit the file "dbmslmd.sql" located in the "$ORACLE_HOME/rdbms/admin"

directory.

Change the line:

TYPE col_desc_array IS VARRAY(513) OF col_description;

to

TYPE col_desc_array IS VARRAY(700) OF col_description;

Save the file.

2. Run the newly modified script:

SQLPLUS> Connect internal

SQLPLUS> @$ORACLE_HOME/rdbms/admin/dbmslmd.sql

3. Recompile the package body DBMS_LOGMNR_D:

SQLPLUS> alter package DBMS_LOGMNR_D compile body;

[krw]

Thanks Julian.

I also found this on metalink and it worked!

Thanks again!