|Oracle8i Supplied PL/SQL Packages Reference
Release 2 (8.1.6)
Part Number A76936-01
DBMS_LOGMNR_D, 2 of 2
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
UTL_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 (ORA: 942) may be issued during the dictionary build. This is expected behavior.
This example creates a dictionary file as:
The procedure reports an
ORA-1309 error under the following conditions: