检查Oracle数据库有多老？ [英] Check how old an Oracle database is?

问题描述

因此，我们有一个生产数据库的版本的镜像。

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

无论如何（您知道）是否在那儿找出数据库的年代？

Is there anyway (that you know of) to find out how old the database is?

ie

感谢您的帮助！

推荐答案

select是从dba_users创建的，其中username ='SYS';

select created from dba_users where username = 'SYS';

在我的网站上，
与SELECT MIN（created）FROM有16秒的区别dba_objects;
怎么可能在创建用户SYS之前16秒在SYS中创建对象？

at my site there's a 16 seconds difference with SELECT MIN(created) FROM dba_objects; How is that possible, the objects in SYS are created 16 seconds before user SYS 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        

更新：注意：我的答案是不正确（在所有情况下）。亚当和道格曼给出了正确的答案。请参阅stackoverflow.com/questions/2537342/…当您使用DBCA创建数据库并使用数据文件模板时，用户SYS和SYS对象的创建日期是模板文件的创建日期，而不是数据库的创建日期。

UPDATE : BEWARE : My answer is not correct (in all circumstances). The right answer is given by Adam and Dougman. See stackoverflow.com/questions/2537342/… When you create a database with DBCA and use datafile templates the creation date of user SYS and SYS objects is the date the template files are created, not the date the database is created.

这篇关于检查Oracle数据库有多老？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！