RE: best way to determine whether data in a table has changed in the last 24 hours
From: Job Miller <jobmiller_at_yahoo.com>
Date: Thu, 18 Dec 2008 17:20:56 -0800 (PST)
Message-ID: <18900.71904.qm@web53906.mail.re2.yahoo.com>
Date: Thu, 18 Dec 2008 17:20:56 -0800 (PST)
Message-ID: <18900.71904.qm@web53906.mail.re2.yahoo.com>
That sounds like a good chance to do a TSPITR up to point of truncate, followed by an export/import.
I am sure you practice that regularly right?
If not, it isn't too bad. You do have archive logs since the last backup I assume?
Logminer has an OEM interface as well I believe (if you don't have Toad), although I haven't had the good fortune to test it out.
Job
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Dec 18 2008 - 19:20:56 CST