Oracle8i Supplied Packages Reference Release 8.1.5 A68001-01 |
|
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.
DBMS_LOGMNR_D
.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.
DBMS_LOGMNR_D.BUILD ( dictionary_filename IN VARCHAR2, dictionary_location IN VARCHAR2);
Parameter | Description |
---|---|
dictionary_filename |
Name of the dictionary file. |
dictionary_location |
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.
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.
This example creates a dictionary file as:
/oracle/database/l_dictionary.ora
SVRMGR> EXECUTE dbms_logmnr_d.build('l_dictionary.ora', SVRMGR> '/oracle/database/');