Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Oracle (https://www.askmehelpdesk.com/forumdisplay.php?f=443)
-   -   Creation day of oracle database (https://www.askmehelpdesk.com/showthread.php?t=114288)

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

    Thank you
    Sam
  • Oct 5, 2007, 03:18 PM
    DaBaAd
    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.

    • All times are GMT -7. The time now is 05:24 PM.