My Oracle Support Banner

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.

Purpose

  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. 

Scope

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. 

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.