Re: last time a table was modified

From: Graham Wallace <graham.wallace_at_NOSPAM.blueyonder.co.uk>
Date: Fri, 04 Aug 2006 19:16:03 GMT
Message-ID: <T1NAg.47483$F8.19901@fe3.news.blueyonder.co.uk>

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.
>

Look at the all_objects view, in particular the LAST_DDL_TIME field.

See
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14237/statviews_2005.htm#sthref1428 for more information

Graham Received on Fri Aug 04 2006 - 14:16:03 CDT

This message: [ Message body ]
Next message: laredotornado_at_zipmail.com: "indexes"
Previous message: DA Morgan: "Re: last time a table was modified"
In reply to: mike7411_at_gmail.com: "last time a table was modified"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US