How to use LogMiner to Extract SQL Redo for DML Against Dropped Table
(Doc ID 148937.1)
Last updated on OCTOBER 18, 2023
Applies to:Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Information in this document applies to any platform.
This note discusses and demonstrates how to locate and analyze DML (INSERT, UPDATE, DELETE) on a dropped non-partitioned table (DROP TABLE) in online and archived redo logs using LogMiner. This approach will not work with RANGE, HASH or Composite partitioned tables.
This article is not intended to present LogMiner basics - refer to the Oracle8i Administrator's Guide and Supplied Packages Reference for an introduction to LogMiner and for general instructions.
This article assumes the reader has basic understanding of fixed tables and LogMiner.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!