RE: best way to determine whether data in a table has changed in the last 24 hours
Date: Thu, 18 Dec 2008 17:20:56 -0800 (PST)
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.
JobReceived on Thu Dec 18 2008 - 19:20:56 CST