RE: best way to determine whether data in a table has changed in the last 24 hours
- From: "Kenneth Naim" <kennaim@xxxxxxxxx>
- To: <chris_stephens@xxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 18 Dec 2008 11:22:24 -0500
Log miner would be the way to go. Toad has a GUI for it.
Ken
_____
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Stephens, Chris
Sent: Thursday, December 18, 2008 10:19 AM
To: oracle-l@xxxxxxxxxxxxx
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.
Thanks!
Chris
CONFIDENTIALITY NOTICE:
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.
Other related posts:
