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
Oracle
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