Re: last time a table was modified

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.

The table or the data within the table? There is a difference.

SELECT object_name, last_ddl_time
FROM all_objects;

Will get you one of them. The other requires either adding a column as Sybrand states or, if you are in 10g, building the table with ROWDEPENDENCIES which will add 6 bytes to each row but store the row's SCN in the block. You can then use SCN_TO_TIMESTAMP to identify when a record was last altered.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org