oracle 数据库的创建日期
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/2537342/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
the creation date of a database
提问by Rob van Laarhoven
This is a question that originated from thisquestion by Jamie.
这个问题源于杰米的这个问题。
I thought I'll check Dougman's answer. What's happening here? A restore?
我想我会检查 Dougman 的回答。这里发生了什么事？还原？
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.
从 v$database 创建比用户 SYS 和 SYS 对象的创建日期晚一年多。
采纳答案by APC
If you ask for slightly more detail in the first two queries you'll find that the schemas are Oracle's default ones:
如果您在前两个查询中询问更多详细信息，您会发现这些模式是 Oracle 的默认模式：
SQL> select owner, min(created), max(created)
2 from dba_objects
3 where created < (select created from v$database)
4 group by owner
5 /
OWNER MIN(CREATED) MAX(CREATED)
------------------------------ -------------------- --------------------
PUBLIC 15-OCT-2007 10:09:10 15-OCT-2007 11:08:07
OUTLN 15-OCT-2007 10:09:17 15-OCT-2007 10:11:32
CTXSYS 15-OCT-2007 10:35:41 15-OCT-2007 10:36:12
SYSTEM 15-OCT-2007 10:09:22 15-OCT-2007 10:48:40
SCOTT 15-OCT-2007 11:36:01 15-OCT-2007 11:36:01
XDB 15-OCT-2007 10:36:34 15-OCT-2007 10:53:50
SYS 15-OCT-2007 10:09:07 15-OCT-2007 12:01:43
....
21 rows selected.
SQL>
On my database the value for CREATED is before I installed Oracle on my machine. So I think the dates represent when Oracle populated the data dictionary for that version of Oracle.
在我的数据库上，CREATED 的值是在我在我的机器上安装 Oracle 之前的值。所以我认为日期代表 Oracle 为该版本的 Oracle 填充数据字典的时间。
edit
编辑
Yep, it could be the dates in the DCBA templates; certainly my database was built using them.
是的，可能是 DCBA 模板中的日期；当然，我的数据库是使用它们构建的。
