Re: last update to a table

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 16 Feb 2001 06:49:59 +0100
Message-ID: <t8pg0k23aa629d@beta-news.demon.nl>

There is only one way:
maintain a timestamp in your record.
Other than that you would need to use logminer for similar results. The time of the last update is *NOT* being maintained in the dictionary.

Hth,

Sybrand Bakker, Oracle DBA

"Thomas Tomello" <tom_at_tatsoft.com> wrote in message news:9I2j6.12222$Nj5.794850_at_bgtnsc07-news.ops.worldnet.att.net...
> Can someone tell me if there is a way, dynamic view or whatever, to tell
> when the last time an update was made to a table? Thanks.......
>
>
Received on Thu Feb 15 2001 - 23:49:59 CST