To run LogMiner, you use the
DBMS_LOGMNR PL/SQL package. Additionally, you might also use the
DBMS_LOGMNR_D package if you choose to extract a LogMiner dictionary rather than use the online catalog.
DBMS_LOGMNR package contains the procedures used to initialize and run LogMiner, including interfaces to specify names of redo log files, filter criteria, and session characteristics. The
DBMS_LOGMNR_D package queries the database dictionary tables of the current database to create a LogMiner dictionary file.
The LogMiner PL/SQL packages are owned by the
SYS schema. Therefore, if you are not connected as user
You must include
SYS in your call. For example:
You must have been granted the
Oracle Database PL/SQL Packages and Types Reference for details about syntax and parameters for these LogMiner packages
Oracle Database Development Guide for more information about PL/SQL packages