Home » Other » General » last time table was modified. (10gR2, W2K3)
last time table was modified. [message #402847] Tue, 12 May 2009 14:38 Go to next message
Messages: 5
Registered: June 2005
Junior Member
Is there a way to know when data in a table was last modified?

Re: last time table was modified. [message #402848 is a reply to message #402847] Tue, 12 May 2009 14:47 Go to previous message
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
It depends.
Maybe yes, maybe no.
It depends upon about when the last change occurred; within last day vs. more than 1 year ago.
It depends upon level of effort to obtain the answer (LOG MINER).
Possibly yes & possibly no.
Previous Topic: ORACLE 10g new features
Next Topic: Update Query Working very slow
Goto Forum:

Current Time: Tue Aug 16 11:10:28 CDT 2022