Home » SQL & PL/SQL » SQL & PL/SQL » TO know when the table is updated (Oracle 10g)
TO know when the table is updated [message #404716] Sat, 23 May 2009 00:49 Go to next message
ramesh55.sse
Messages: 262
Registered: December 2008
Location: Hyderabad
Senior Member
How can i know when the data in the table is updated,
and also when the table structure is modified.Please help me
Re: TO know when the table is updated [message #404729 is a reply to message #404716] Sat, 23 May 2009 01:25 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
You don't bother to search...Right?
check all_objects.last_ddl_time
and this link.

By
Vamsi
Re: TO know when the table is updated [message #404731 is a reply to message #404716] Sat, 23 May 2009 01:28 Go to previous message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do you think you are the first one to post this question?
Please search before posting.

Regards
Michel
Previous Topic: Convert into partition table
Next Topic: mutating error (merged)
Goto Forum:
  


Current Time: Fri Dec 09 21:03:52 CST 2016

Total time taken to generate the page: 0.09781 seconds