Re: How to find view creation date and time

Thanks.

"Roger Skoglund" <rskglnd_at_online.no> wrote in message news:<VfcU9.10292$Rc7.193373_at_news2.e.nsc.no>...
> Yes. Oracle 8i have the same object.
>
> /roger
>
> "DL" <donlcs_at_yahoo.com> wrote in message
> news:604bb90c.0212191446.49e8f706_at_posting.google.com...
> > 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 Sun Jan 12 2003 - 21:19:32 CET