Re: Date and Time of table creation - V$ ?

the only way i know of to have oracle record a "create table" event is to enable auditing of this activity...

HTH "Stan Novinsky" <stan.novinsky_at_jhuapl.edu> wrote in message news:3A79A56A.94BFA04B_at_jhuapl.edu...
> Thanks..
>
> What about a history for a table if is created at three different time
> since the DB was
> created ...
>
> I need to find the dates of when a table that was created at 3 different
> times over the last year
>
> Thanks
>
> Terry Dykstra wrote:
>
> > dba_objects
> >
> > --
> > Terry Dykstra
> > Canadian Forest Oil Ltd.
> > "Stan Novinsky" <stan.novinsky_at_jhuapl.edu> wrote in message
> > news:3A7830D2.46641F1D_at_jhuapl.edu...
> > > Is there a V$ table or any other DBA table that can list when a table
> > > was created (date/time) ?
> > >
> > > Oracle 8.0.5 Server
> > >
> > > Thanks
> > >
> > > stan.novinsky_at_jhuapl.edu
> > >
> > >
>
>
Received on Thu Feb 01 2001 - 23:01:07 CST