Why not just find out when the SYSTEM tablespace was created?
select fn.fnnam
, fe.FECRC_tim
from x$kccfe fe
, x$kccfn fn
where fe.fedup!=0
and fe.indx+1=fn.fnfno
and fn.fnnam is not null
and fn.fnnam = '&Filename'
/
SQL> @when_datafile
Enter value for filename: /hours_sys/dbs/SYSTEM_1.dbf
FNNAM
------------------------------------------------------------
----------------------------------------------------
FECRC_TIM
--------------------
/hours_sys/dbs/SYSTEM_1.dbf
11/18/2002 16:02:16
1 SELECT dbid, name, created
2* FROM v$database
DBID NAME CREATED
---------- --------- ---------
3144342586 HOURS 18-NOV-02
Gives the same result ...
I suspect that the database has been rebuilt at some point if the date
doesn't match that in v$database. It may even have been migrated from one
version to another - Im pretty certain that resets the CREATED date in
v$database.
Adam
-----Original Message-----
From: Misheil Meshreky
[mailto:oracledba-ezmlmshield-x36159672.[Email address protected]
Sent: 03 January 2007 17:44
To: LazyDBA Discussion
Subject: how can i get the database creation date?
hi
can some one tell me how can I get the first date the database created?
becaose I used
SELECT dbid, name, created
FROM v$database;
and I got 17-jul-06
which it didn't make any since for me becaose I know the database was
created early befor
I need help
Thanks
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
****************************************************************************
****
IMPORTANT NOTICE
House of Fraser (Stores) Limited
Registered office: Granite House, 31 Stockwell Street, Glasgow G1 4RZ
Company Number: 10677
If you have received this e-mail in error, please notify the sender and
delete the e-mail and attachments immediately. This e-mail (including any
attachments) may contain confidential and/or privileged information. If you
are not the intended recipient, any reliance on, use, disclosure,
dissemination, distribution or copying of the e-mail or attachments is
strictly prohibited.
We have checked for viruses but the content of an attachment may still
contain software viruses, which could damage your computer system. We do not
accept liability for any damage you sustain as a result of a virus
introduced by this e-mail or attachment and you are advised to use
up-to-date virus checking software. E-mail transmission cannot be guaranteed
to be secure or error free.
This e-mail is not intended nor should it be taken to create any legal
relations, contractual or otherwise.
To view our latest in-store news click on: http://www.houseoffraser.co.uk
****************************************************************************
****
Oracle LazyDBA home page