Re: When a table was created?

"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

--------- --------- -------------------

• Mark D Powell --