Re: When a table was created?

Hello,
try this:

select created, last_ddl_time
from user_objects
where object_name like '%XYZ%'

Ales

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.
>
> --
> "Sage nicht immer, was du weißt, aber wisse immer, was du sagst." -
Matthias
> Claudius
> "If you haven't got anything to say, don't say it." - My mother.
>
>
Received on Tue Aug 14 2001 - 10:01:43 CDT