20
DBMS_LOGMNR_D

DBMS_LOGMNR_D contains the LogMnr procedure to create the LogMnr dictionary file. This procedure queries the dictionary tables of the current database and creates a text-based file containing their contents. The external dictionary file is created in preparation of future analysis of log files using the LogMnr tool.

Creating a Dictionary File

You create a dictionary file by mounting a database and then extracting dictionary information into an external file. You must create the dictionary file from the same database that generated the log files you want to analyze. After it is created, you can use the dictionary file to analyze log files.

1. Mount and then open the database whose files you want to analyze.

2. Run the PL/SQL procedure DBMS_LOGMNR_D.BUILD. This procedure creates the dictionary file, which you should use to analyze log files.

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 20-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 UTIL_FILE_DIR parameter in init.ora.

SET SERVER OUTPUT 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 (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

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