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

Report message to a moderator

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: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 01 14:46:39 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.