Re: last time a table was modified

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 04 Aug 2006 20:39:42 +0200
Message-ID: <b057d2lgjvki11rl3an7tq07uj6dad1jjf@4ax.com>

On 4 Aug 2006 10:29:21 -0700, mike7411_at_gmail.com wrote:

>Is there a way to check the last time a table was modified?
>
>Is this a built-in Oracle field for all tables?
>
>Thanks.

No there is not. Oracle only keeps the date the table was last ALTERed.
You would need to add a column called last_modification_date, and manipulate that using a before insert or before update for each row trigger.

--
Sybrand Bakker, Senior Oracle DBA

Received on Fri Aug 04 2006 - 13:39:42 CDT