Home » RDBMS Server » Server Administration » how to find updated table (oracle 11g)
how to find updated table [message #546819] Fri, 09 March 2012 02:27 Go to next message
sathish16787
Messages: 56
Registered: September 2011
Location: mumbai
Member
Hi,

how to find a table is updated and when the table is updated.



Regards,
Sathish
Re: how to find updated table [message #546827 is a reply to message #546819] Fri, 09 March 2012 02:58 Go to previous message
Michel Cadot
Messages: 59427
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Activating AUDIT (or creating a trigger on UPDATE) otherwise the only way is to mine the logs or, if it has not be done so long ago, you can query FLASHBACK_TRANSACTION_QUERY.

Regards
Michel
Previous Topic: UTL_SMTP
Next Topic: upgrade to 11.2.0.3 stuck at execute dbms_registry_sys.gather_stats(null); for 4 hours. (2 mERGED)
Goto Forum:
  


Current Time: Sat Oct 25 03:59:54 CDT 2014

Total time taken to generate the page: 0.08137 seconds