PDA

View Full Version : Creation day of oracle database


sghandch
Jul 28, 2007, 10:19 AM
How to find out when Oracle database was created by writing a sql?

Thank you
Sam

DaBaAd
Oct 5, 2007, 03:18 PM
How to find out when Oracle database was created by writing a sql?

Thank you
Sam
Sign into Oracle as sys or system.

Issue the following SQL:

SQL> select created from v$database;


You should see something like:

CREATED
---------
26-FEB-07

Hope this helps.