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
Messages: 56
Registered: September 2011
Location: mumbai

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

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: 61966
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.

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

Current Time: Tue Oct 13 09:30:57 CDT 2015

Total time taken to generate the page: 0.14354 seconds