Re: last time a table was modified

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 14 Aug 2006 10:32:56 -0700
Message-ID: <1155576775.988167.131200@m79g2000cwm.googlegroups.com>

mike7411_at_gmail.com wrote:
> What is the easiest way to maintain a time stamp variable that keeps
> track of the last time a table was modified?
>
> Is it to set up triggers that fire upon insert, update, and delete?
>
> Thank you.

What edition and version of Oracle?

Maintain a time stamp variable, where? For what purpose?

The answer depends on what exactly you need to do and why?

The options are most likely:
1- The built-in AUDIT command
2- DML table triggers
3 - FGA (Fine Group Auditing)

HTH -- Mark D Powell -- Received on Mon Aug 14 2006 - 12:32:56 CDT