Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Date and Time of table creation - V$ ?
In our last gripping episode Stan Novinsky <stan.novinsky_at_jhuapl.edu>
wrote:
> 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
>
>
Select object_name, created
from dba_objects
where object_type = 'TABLE';
-- David Fitzjarrell Oracle Certified DBA Sent via Deja.com http://www.deja.com/Received on Wed Jan 31 2001 - 10:23:31 CST