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

> -----Original Message-----
> From: Leslie Lu [mailto:[EMAIL PROTECTED]]
> 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$' ;

Reply via email to