RE: when did that happen ... (really like to know)

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Thu, 01 Feb 2001 01:16:17 -0800
Message-ID: <F001.002A6B1C.20010131172044@fatcity.com>

> -----Original Message-----
> From: Leslie Lu [mailto:leslie_y_lu_at_yahoo.com]
> Sent: mercredi, 31. janvier 2001 16:35
>
> Is there a way to find out when was a database created

select to_char (created, 'SYYYY/MM/DD HH24:MI:SS') from v$database ;

> and also when was an individual object in a database
> created?

select to_char (created, 'SYYYY/MM/DD HH24:MI:SS') from dba_objects
where owner = 'SYS' and object_name = 'TAB$' ; Received on Thu Feb 01 2001 - 03:16:17 CST