the creation date of a database

Posted by Robert Merkwürdigeliebe on Stack Overflow See other posts from Stack Overflow or by Robert Merkwürdigeliebe
Published on 2010-03-29T10:59:59Z Indexed on 2010/03/29 11:03 UTC
Read the original article Hit count: 270

Filed under:

This is a question that originated from this question by Jamie.

I thought I'll check Dougman's answer. What's happening here? A restore?

select created from dba_users where username = 'SYS';

select min(created) FROM dba_objects;

select created from v$database;

CREATED                   
------------------------- 
10-SEP-08 11:24:44        

MIN(CREATED)              
------------------------- 
10-SEP-08 11:24:28        

CREATED                   
------------------------- 
18-DEC-09 15:49:00      

Created from v$database is more than one year later than creation date of user SYS and SYS' objects.

© Stack Overflow or respective owner

Related posts about Oracle