Re: How to find view creation date and time
Date: Wed, 18 Dec 2002 14:51:43 -0600
Message-ID: <Ad5M9.35$HE3.97177_at_news.uswest.net>
Don - Look at ALL_OBJECTS instead ALL_VIEWS, and check the CREATED column.
For example,
SELECT owner, object_name, to_char(created, 'DD-MON-YYYY HH12:MI:SS AM')
as CREATED
FROM all_objects
WHERE object_type = 'VIEW'
--
Cheers,
Chris
___________________________________
Chris Leonard, The Database Guy
http://www.databaseguy.com
Brainbench MVP for Oracle Admin
http://www.brainbench.com
MCSE, MCDBA, MCT, OCP, CIW
___________________________________
"DL" <donlcs_at_yahoo.com> wrote in message
news:604bb90c.0212180917.204622a4_at_posting.google.com...
> Hello,
>
> We're on Oracle 9i for Windows.
> I have no problem finding all the views available to the current user,
> but how can I find each view's creation date and time? I can't
> determine it by merely looking at the SQL statement for "all_views"
> sys object. Thanks.
>
> Don
Received on Wed Dec 18 2002 - 21:51:43 CET