Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> 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
--------- --------- -------------------
![]() |
![]() |