Home » RDBMS Server » Server Administration » Objects displays incorrect date (merged 3) (Oracle Database, 10.2.0.1, Windows 2003 Server)
Objects displays incorrect date (merged 3) [message #426844] Tue, 20 October 2009 01:41 Go to next message
saleh_binmasood
Messages: 30
Registered: October 2009
Member
Sir,

I installed Oracle database enterprise edition 10g release 2 before a week.

When i queried dba_objects as given below

SQL> select object_name, owner, created from dba_objects;

it gave me output

OBJECT_NAME OWNER CREATED

ICOL$ SYS 30-AUG-05
I_USER1 SYS 30-AUG-05
.
.
.
etc



Strangely its giving me the date of creation as 30-AUG-05,

WHY?

Thanking you

Re: Objects displays incorrect date [message #426850 is a reply to message #426844] Tue, 20 October 2009 01:46 Go to previous messageGo to next message
Kamran Agayev
Messages: 145
Registered: February 2009
Location: Azerbaijan, Baku
Senior Member

Because you're querying the objects which were created by Oracle at that time
They are mostly default data dictionary views
Re: Objects displays incorrect date (merged 3) [message #426854 is a reply to message #426844] Tue, 20 October 2009 01:55 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You used the template database delivered by Oracle and thus you have the date at which this example database was created.

Regards
Michel
Re: Objects displays incorrect date [message #426862 is a reply to message #426850] Tue, 20 October 2009 02:29 Go to previous messageGo to next message
saleh_binmasood
Messages: 30
Registered: October 2009
Member
You mean the creation of the software ?
Re: Objects displays incorrect date [message #426871 is a reply to message #426862] Tue, 20 October 2009 02:56 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No the creation of the database that is embedded in the Oracle delivery with the software.

Regards
Michel
Re: Objects displays incorrect date [message #426882 is a reply to message #426871] Tue, 20 October 2009 03:27 Go to previous messageGo to next message
saleh_binmasood
Messages: 30
Registered: October 2009
Member
Thanks a lot Michel for information
Re: Objects displays incorrect date [message #426883 is a reply to message #426882] Tue, 20 October 2009 03:47 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Note that it is not mandatory you use this seed database from delivery, you can create your own one with create database statement, for instance, then SYS objects will have the date of your database creation.

Regards
Michel
Re: Objects displays incorrect date [message #427086 is a reply to message #426883] Wed, 21 October 2009 01:03 Go to previous message
saleh_binmasood
Messages: 30
Registered: October 2009
Member
Thanks once more.
Previous Topic: Strange User ***
Next Topic: User like SYS
Goto Forum:
  


Current Time: Fri Dec 09 08:09:54 CST 2016

Total time taken to generate the page: 0.22091 seconds