DBMS_LOGMNR_D.BUILD Procedure

The syntax for the DBMS_LOGMNR_D.BUILD procedure is as follows:

Syntax

DBMS_LOGMNR_D.BUILD (
dictionary_filename IN VARCHAR2,
dictionary_location IN VARCHAR2,
options IN NUMBER);

Parameters

Table 27-1 BUILD Procedure Parameters

Parameter	Description
dictionary_filename	Name of the dictionary file
dictionary_location	Path to file directory
options	Specifies that the dictionary is written to either a flat file (STORE_IN_FLAT_FILE) or the redo log files (STORE_IN_REDO_LOGS) destination

To extract the dictionary to a flat file, you must supply a file name and location.

To extract the dictionary to the redo log files, specify only the STORE_IN_REDO_LOGS option. The size of the dictionary may cause it to be contained in multiple redo logs.

In summary, the combinations of parameters used result in the following behavior:

• If you do not specify any parameters, an error message is returned.

• If you specify a file name and location, without any options, the dictionary is extracted to a flat file with that name.

• If you specify a file name and location, as well as the DBMS_LOGMNR_D.STORE_IN_FLAT_FILE option, the dictionary is extracted to a flat file with the specified name.

• If you do not specify a file name and location, but do specify the DBMS_LOGMNR_D.STORE_IN_REDO_LOGS option, the dictionary is extracted to the redo logs.

• If you specify a file name and location, as well as the STORE_IN_REDO_LOGS option, an error is returned.

Exceptions

• ORA-1308: initialization parameter UTL_FILE_DIR is not set.

• ORA-1336 - this error is returned under the following conditions:
  1. Dictionary_location does not exist.

  2. UTL_FILE_DIR is not set to have access to dictionary_location.

  3. Dictionary_file is read only.

Usage Notes

• Ideally, the dictionary file will be created after all dictionary changes to a database and prior to the creation of any redo log files that are to be analyzed. As of LogMiner version 9i, you can dump the dictionary to the redo log files, perform DDL operations, and dynamically apply the changes to the LogMiner dictionary.

• To monitor progress of the dictionary build issue the SET SERVEROUTPUT ON command.