Re: Table Creation Date & Time

Scott,

  You can find this information in the dba_objects view. Try this:

  select object_name, created, last_ddl_time from dba_objects   where object_name='YOUR TABLE HERE';

 That should do it!

Steve

Steve Miller
Database Administrator
Oracle Certified Professional - DBA
smiller_at_gers.com
http://www.gers.com

Scott C. <sdcairns_at_mindspring.com> wrote in article <6piea3$mo7$1_at_camel29.mindspring.com>...
> Where can I find the creation date & time of a user table in the Oracle
> (8.x) data dictionary?
>
>
>
Received on Tue Jul 28 1998 - 14:56:21 CDT