Summary of Subprograms

DBMS_LOGMNR_D contains one procedure: BUILD. This creates the dictionary file, which you should use to analyze log files.

BUILD Procedure

This procedure queries the dictionary tables of the current database, and creates a text based file containing their contents.

Syntax

DBMS_LOGMNR_D.BUILD (
   dictionary_filename IN VARCHAR2,
   dictionary_location IN VARCHAR2);

Parameters

Table 21-1 BUILD Procedure Parameters

dictionary_filename

dictionary_location

Usage Notes

The dictionary file should be created after all dictionary changes to a database and prior to the creation of any log files that are to be analyzed.

The BUILD procedure uses the UTL_FILE package which requires setting the
UTL_FILE_DIR parameter in init.ora.

SET SERVEROUTPUT ON to monitor progress of the dictionary build.

Some tables written to the dictionary file do not exist on pre-8i databases. In this case, one or more errors (ORA: 942) may be issued during the dictionary build. This is expected behavior.

Example

This example creates a dictionary file as:

/oracle/database/l_dictionary.ora

SQLPLUS>EXECUTE dbms_logmnr_d.build('l_dictionary.ora',  
SQLPLUS>'/oracle/database/');  

Exceptions

• ORA-1308: initialization parameter UTL_FILE_DIR is not set.

The procedure reports an ORA-1309 error under the following conditions:

1. Dictionary_location does not exist.

2. UTL_FILE_DIR is not set to have access to dictionary_location.

3. Dictionary_file is read only.