|Oracle9i Supplied PL/SQL Packages and Types Reference
Release 1 (9.0.1)
Part Number A89852-02
DBMS_LOGMNR_D , 2 of 2
The syntax for the
BUILD procedure is as follows:
DBMS_LOGMNR_D.BUILD ( dictionary_filename IN VARCHAR2, dictionary_location IN VARCHAR2, options IN NUMBER);
Name of the dictionary file
Path to file directory
Specifies that the dictionary is written to either a flat file (
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:
DBMS_LOGMNR_D.STORE_IN_FLAT_FILEoption, the dictionary is extracted to a flat file with the specified name.
DBMS_LOGMNR_D.STORE_IN_REDO_LOGSoption, the dictionary is extracted to the redo logs.
STORE_IN_REDO_LOGSoption, an error is returned.
UTL_FILE_DIRis not set.
ORA-1336 - thiserror is returned under the following conditions: