creation day of oracle database

sghandch · #1 Jul 28, 2007, 09:19 AM

How to find out when Oracle database was created by writing a sql?

Thank you
Sam

DaBaAd · Oct 5, 2007, 02:18 PM

Quote:

Originally Posted by sghandch

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.



At Ask Me Help Desk you can ask questions in any topic and have them answered for free by our experts. To ask questions or participate in answering them you must register for a free account. By registering you will be able to: Get free answers from experts in any of our 300+ topics. Accept money for answers that you provide. Communicate privately with other members (PM). See fewer ads. Sign Up!