Re: Table last alter

"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

select last_ddl_time, timestamp
from user_objects
where object_name = 'FOO'
and object_type = 'TABLE';

//Rauf Sarwar Received on Tue Aug 13 2002 - 15:21:37 CDT