21
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.

See Also: Oracle8i Administrator's Guide and Oracle8i Backup and Recovery Guide

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.