|Oracle8i Supplied Packages Reference
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.
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.
BUILD. This procedure creates the dictionary file, which you should use to analyze log files.
DBMS_LOGMNR_D contains one procedure:
BUILD. This creates the dictionary file, which you should use to analyze log files.
This procedure queries the dictionary tables of the current database, and creates a text based file containing their contents.
Name of the dictionary file.
Path to file directory.
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.
BUILD procedure uses the
UTL_FILE package which requires setting the
UTIL_FILE_DIR parameter in
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.
This example creates a dictionary file as: