Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: when did that happen ... (really like to know)

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

From: Joseph S. Testa <teci_at_oracle-dba.com>
Date: Wed, 31 Jan 2001 20:35:46 -0500
Message-Id: <10758.128006@fatcity.com>


select * from v$database;

select * from sys.dba_objects where ....;

joe
Leslie Lu wrote:
>
> Hi,
>
> Is there a way to find out when was a database created
> and also when was an individual object in a database
> created?
>
> Thanks in advance.
>
> Leslie

-- 
Joe Testa  http://www.oracle-dba.com
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
Received on Wed Jan 31 2001 - 19:35:46 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US