Re: How to find view creation date and time

Thanks, Chris, I don't have a quick access to an Oracle8i server at the moment, does Oracle8i have "all_objects" object as well? Just curious.

Happy Holiday!

Don

"Chris Leonard" <s_p_a_m_chris_at_hotmail.com> wrote in message news:<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 Thu Dec 19 2002 - 23:46:37 CET