Month: February 2016

Using the LogMiner to search for transactions in the Oracle database
By: Date: February 27, 2016 Categories: LogMiner,Oracle

Oracle offers the dbms_logmnr package to look inside the archivelogs of the database. you can only view every DML with the LogMiner if you have previously enabled at least minimal supplemental logging. To verify if it is enabled you can run the following query: SQL> select SUPPLEMENTAL_LOG_DATA_MIN from v$database; SUPPLEME ——– YES   Now let’s say we need to…

Read More →