Re: How to find view creation date and time

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 - 12:24:36 CET