Message-Id: <10758.128004@fatcity.com> From: Jacques Kilchoer Date: Wed, 31 Jan 2001 17:19:25 -0800 Subject: RE: when did that happen ... (really like to know) This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C08BED.0402DB60 Content-Type: text/plain; charset="iso-8859-1" > -----Original Message----- > From: Leslie Lu [mailto:leslie_y_lu@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$' ; ------_=_NextPart_001_01C08BED.0402DB60 Content-Type: text/html; charset="iso-8859-1" RE: when did that happen ... (really like to know)

> -----Original Message-----
> From: Leslie Lu [mailto:leslie_y_lu@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$' ;