Re: Timestamp of Last update on a TABLE.

From: John K. Hinsdale <hin_at_alma.com>
Date: 17 Jan 2007 06:23:27 -0800
Message-ID: <1169043807.583240.180080@11g2000cwr.googlegroups.com>

joel garry wrote:
> chandu wrote:
> > Hi All,
> >
> > Is there any way/command of getting the TIME STAMP OF LAST UPDATE MADE
> > on ORACLE TABLE ?

A Google search on the keywords

oracle table time of last update

yields the following link as the top hit:

http://www.jlcomp.demon.co.uk/faq/table_update.html

It describes an approach using Oracle object auditing. Note that the example audits all of the INSERT, SELECT, DELETE and UPDATE "events." Not sure if you need SELECT or DELETE; probably you want just INSERT and UPDATE.

More detailed info can be found in the chapter "Configuring and Administering Auditing" in the Oracle(r) Database Security Guide.

Cheers,

John Hinsdale Received on Wed Jan 17 2007 - 08:23:27 CST