Re: Table last alter

From: Jusung Yang <jusungyang_at_yahoo.com>
Date: 13 Aug 2002 11:38:04 -0700
Message-ID: <42ffa8fa.0208131038.61be0875@posting.google.com>

select LAST_DDL_TIME from dba_objects where object_name=<table name>;

should do it. Use USER_OBJECTS instead, if you can not access DBA* views and are the owner of the table.

"Matthieu DEGLIN" <mdeglin<remove-me>@partner.auchan.fr> wrote in message news:<ajb26d$dho$1_at_reader1.imaginet.fr>...
> Hi,
> can anybody tell me how to get the date-time of the last 'alter' of a table.
>
> Thank you.
>
> Matthieu
Received on Tue Aug 13 2002 - 13:38:04 CDT