|Oracle9i Supplied PL/SQL Packages and Types Reference
Release 1 (9.0.1)
Part Number A89852-02
DBMS_LOGMNR_D contains the LogMiner procedure,
DBMS_LOGMNR_D.BUILD, used to create the LogMiner dictionary file. This procedure extracts the dictionary either to the redo log files or to a flat file.
This information is saved in preparation for future analysis of redo log files using the LogMiner tool.
This chapter discusses the following topics:
To extract a dictionary file to the redo log files, the following conditions must be met:
DBMS_LOGMNR_D.BUILDprocedure must be run on a system that is running Oracle9i or later
DBMS_LOGMNR_D.BUILD procedure will not run if there are any ongoing DDL operations.
Additionally, while the procedure is executing, no DDL operations are allowed.
When extracting a dictionary to a flat file, the procedure queries the dictionary tables of the current database and creates a text-based file containing the contents of the tables.
To extract a dictionary to a flat file, the following conditions must be met:
The dictionary file must be created from the same database that generated the redo log files you want to analyze
UTL_FILE_DIRin the init.ora file. For example:
If you do not set this parameter, the procedure will fail.
DBMS_LOGMNR_D package contains one procedure,
BUILD. For a complete description of this procedure, see DBMS_LOGMNR_D.BUILD Procedure.
To use the
DBMS_LOGMNR_D.BUILD procedure, mount and open the database whose files you will want to analyze.
Then run the PL/SQL procedure
BUILD,as illustrated in the following examples.
The following example extracts the dictionary file to a flat file named
dictionary.ora in a specified path (
SQLPLUS>EXECUTE dbms_logmnr_d.build('dictionary.ora', SQLPLUS>'/oracle/database/', SQLPLUS>options => dbms_logmnr_d.store_in_flat_file);
DBMS_LOGMNR_D contains one procedure,
BUILD, which writes the dictionary tables of the current database (the online catalog) into the redo log files or into a flat file.