Check how old is the Oracle database?

Question

So, we have a mirror of the Santi version of the production database.

In any case (what do you know) to find out how old the database is?

i.e. when the database was placed on an Oracle server.

Thanks for any help!

Answer 1

select created from dba_users, where username = 'SYS';

there is a 16 second difference on my site with SELECT MIN (created) FROM dba_objects; How is this possible, objects in SYS are created 16 seconds before the SYS user is created?

SQL>select created from dba_users where username = 'SYS'; SQL>SELECT MIN(created) FROM dba_objects; CREATED ------------------------- 10-SEP-08 11:24:44 MIN(CREATED) ------------------------- 10-SEP-08 11:24:28 

UPDATE: CAUTION: My answer is incorrect (under any circumstances). The correct answer is given by Adam and Dugman. See Stackoverflow.com/questions/2537342 / ... When you create a database with DBCA and use data file templates, the date the user created the SYS and SYS objects is the date the template files were created, not the date the database was created.

Answer 2

You can request the time when the first object was created:

 SELECT MIN(created) FROM dba_objects 

Answer 3

select created from v$database;

documentation documentation v $