RE: best way to determine whether data in a table has changed in the last 24 hours

From: Terrian, Thomas J Mr CTR DLA J6DIB <>
Date: Thu, 18 Dec 2008 10:55:00 -0500
Message-ID: <B538F62DA0448741B308EA69417CC30209370A@COL1SMX19.USE.AD.DLA.MIL>

Have you enabled table monitoring?.....if so query dba_tab_modifications to see if that tells you anything.

-----Original Message-----
[] On Behalf Of Stephens, Chris Sent: Thursday, December 18, 2008 10:19 AM To:
Subject: best way to determine whether data in a table has changed in the last 24 hours

One of our developers accidentally truncated a production table. That table is infrequently updated/inserted into.  

I quickly found out that flashback table does not work across truncate commands.  

Luckily I take a nightly datapump export and was able to use that to re-populate the table.  

It isn't critical that we confirm that data in the table has not changed since the datapump export but I would like to do so. My first thought is logminer but I can't seem to find a GUI anywhere (Grid Control or the Java Console) like there used to be. What happened to that thing?  

Is logminer that the only way to look at all the transactions where the table in question was involved?  

If so, I get it is time to read up on logminer.  



This message is intended for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient or the employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by email reply.

Received on Thu Dec 18 2008 - 09:55:00 CST

Original text of this message