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
dstomcat
Messages: 5
Registered: June 2005
Junior Member
Is there a way to know when data in a table was last modified?

thanks,
David
Re: last time table was modified. [message #402848 is a reply to message #402847] Tue, 12 May 2009 14:47 Go to previous message
BlackSwan
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: Sat Dec 07 03:44:17 CST 2024