Ooooh !
Looks like it should be on the FAQ !
--
Jonathan Lewis
Seminars on getting the best out of Oracle
Last few places available for Sept 10th/11th
See http://www.jlcomp.demon.co.uk/seminar.html
Mark D Powell wrote in message
<178d2795.0108140832.119a5a14_at_posting.google.com>...
>"Geoff May" <Geoff.May_at_doka.de> wrote in message
news:<3b7938c1$0$237$4dbef881_at_businessnews.de.uu.net>...
>> Hello all,
>>
>> Does ORACLE store a time stamp when a table was created and/or altered?
>>
>> For example, I'd like to do something like:
>>
>> SELECT CREATE_TIMESTAMP, MODIFIED_TIMESTAMP
>> FROM SOME_SYSTEM_TABLE
>> WHERE TABLE_NAME LIKE '%XYZ%'
>>
>> MfG
>>
>> Geoff.
>
>Look at the dictionary table all_objects, dba_objects or user_objects
>documented in the Oracle 8i Reference Manual.
>
>UT1> select created, last_ddl_time, timestamp
> 2 from dba_objects
> 3 where object_name = 'MARKTEST';
>
>CREATED LAST_DDL_ TIMESTAMP
>--------- --------- -------------------
>30-JUN-01 09-AUG-01 2001-06-30:13:00:57
>
>-- Mark D Powell --
Received on Tue Aug 14 2001 - 11:56:58 CDT
