OraFAQ Forum: Server Administration » Objects displays incorrect date (merged 3)

Home » RDBMS Server » Server Administration » Objects displays incorrect date (merged 3) (Oracle Database, 10.2.0.1, Windows 2003 Server)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Objects displays incorrect date (merged 3) [message #426844]

Tue, 20 October 2009 01:41

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

Report message to a moderator

Re: Objects displays incorrect date [message #426850 is a reply to message #426844]

Tue, 20 October 2009 01:46

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

Report message to a moderator

Re: Objects displays incorrect date (merged 3) [message #426854 is a reply to message #426844]

Tue, 20 October 2009 01:55

Michel Cadot
Messages: 68665
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

Report message to a moderator

Re: Objects displays incorrect date [message #426862 is a reply to message #426850]

Tue, 20 October 2009 02:29

saleh_binmasood
Messages: 30
Registered: October 2009

Member

You mean the creation of the software ?

Report message to a moderator

Re: Objects displays incorrect date [message #426871 is a reply to message #426862]

Tue, 20 October 2009 02:56

Michel Cadot
Messages: 68665
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

Report message to a moderator

Re: Objects displays incorrect date [message #426882 is a reply to message #426871]

Tue, 20 October 2009 03:27

saleh_binmasood
Messages: 30
Registered: October 2009

Member

Thanks a lot Michel for information

Report message to a moderator

Re: Objects displays incorrect date [message #426883 is a reply to message #426882]

Tue, 20 October 2009 03:47

Michel Cadot
Messages: 68665
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

Report message to a moderator

Re: Objects displays incorrect date [message #427086 is a reply to message #426883]

Wed, 21 October 2009 01:03

saleh_binmasood
Messages: 30
Registered: October 2009

Member

Thanks once more.

Report message to a moderator

Previous Topic:	Strange User ***
Next Topic:	User like SYS

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 03 06:41:02 CDT 2024