Ask Experts Questions for FREE Help !
Ask
    sghandch's Avatar
    sghandch Posts: 1, Reputation: 1
    New Member
    		  
    #1

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

    Thank you
    Sam
    DaBaAd's Avatar
    DaBaAd Posts: 271, Reputation: 36
    Full Member
    		  
    #2

    Oct 5, 2007, 03: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.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Creation of 0V neutral [ 4 Answers ]

When an emf is generated in the alternator both poles are simultaneously 0V or at polar opposites in varying degrees of voltage. However in the supply circuit the live is +tve or -tve in varying degrees of voltage & the neutral remains at 0V. So the question is, what happens after the...

Self-referenced table in Oracle 9i database for huge amounts of data [ 5 Answers ]

Hello! I'm designing a database (Oracle 9i) for payments registration system, obviously it will hold a VERY big amount of data, which is going to be changing constantly. There are so called “list payments”, which have several beneficiaries bound to it, additionally for transferring money to some...

Creation science [ 13 Answers ]

I know this one's old, but I hadn't seen it in awhile... “God”, a Scientist exclaims, “we don't need you anymore. We've finally figured out how to create life out of nothing: We can now do what you did in the beginning." God’s eyebrows raise: "Oh, is that so? Tell me... " "Well, " says...

New user creation [ 3 Answers ]

How tocreate new user in xp os

View more questions Search