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

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Wed, 31 Jan 2001 17:19:25 -0800
Message-Id: <10758.128004@fatcity.com>

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_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$' ;

------_=_NextPart_001_01C08BED.0402DB60
Content-Type: text/html;

charset="iso-8859-1"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2652.35">
<TITLE>RE: when did that happen ... (really like to know)</TITLE>
</HEAD>
<BODY>

> -----Original Message-----
 > From: Leslie Lu [<A HREF="mailto:leslie_y_lu_at_yahoo.com">mailto:leslie_y_lu_at_yahoo.com</A>]
 > 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$' ;


</BODY>
Received on Wed Jan 31 2001 - 19:19:25 CST