Home » RDBMS Server » Server Administration » Last Modified Date (AIX 9.2.0.6)
Last Modified Date [message #328376] Thu, 19 June 2008 23:50 Go to next message
pokhraj_das
Messages: 64
Registered: February 2008
Member
Hi,

I want to know my last modified date on any table at my database.

Is there is any query for the same?


Pokhraj

Report message to a moderator

Re: Last Modified Date [message #328378 is a reply to message #328376] Fri, 20 June 2008 00:18 Go to previous message
Michel Cadot
Messages: 68675
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
dba_objects.last_ddl_time if you want modification on your table.
Audit or Log Miner, if you want modification on table data.

Regards
Michel

Report message to a moderator

Previous Topic: DATAFILE DELETED FROM THE DISK
Next Topic: change in nls_length_semantics parameter
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Sep 08 23:28:06 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.