All geek questions in one place

Database Creation Date

This is the question that arose from this question of Jamie.

I thought I would check Dugman's answer. What's going on here? Recovery?

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 the v $ database more than one year after the creation date of the custom SYS and SYS objects.

+4
source share
1 answer

If you ask for a little more detail in the first two queries, you'll see that the schemas are standard by default by 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>

In my database, the value for CREATED is before I installed Oracle on my machine. So I think the dates represent when Oracle entered the data dictionary for this version of Oracle.

change

Yes, it can be dates in DCBA templates; Of course, my database was built with their help.

+3
source

Source: https://habr.com/ru/post/1305445/

More articles:


All Articles