OraFAQ Forum: Security » DBA_REGISTRY_HISTORY is not in database

Home » RDBMS Server » Security » DBA_REGISTRY_HISTORY is not in database (Oracle 9.2.0.3/Windows 2003)

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

DBA_REGISTRY_HISTORY is not in database [message #437903]

Wed, 06 January 2010 08:38

samg4ug
Messages: 33
Registered: July 2007
Location: India

Member

HI,

The view DBA_REGISTRY_HISTORY is not in the database. Is it because no patch is applied till now to the database.

Database/OS -- Oracle 9.2.0.3/Windows 2003

Regards,
Sam G

Report message to a moderator

Re: DBA_REGISTRY_HISTORY is not in database [message #437908 is a reply to message #437903]

Wed, 06 January 2010 08:52

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Database/OS -- Oracle 9.2.0.3/Windows 2003
Unsupported combination above

SQL> desc DBA_REGISTRY_HISTORY
 Name					   Null?    Type
 ----------------------------------------- -------- ----------------------------
 ACTION_TIME					    TIMESTAMP(6)
 ACTION 					    VARCHAR2(30)
 NAMESPACE					    VARCHAR2(30)
 VERSION					    VARCHAR2(30)
 ID						    NUMBER
 COMMENTS					    VARCHAR2(255)

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Prod
PL/SQL Release 10.2.0.4.0 - Production
CORE	10.2.0.4.0	Production
TNS for Linux: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production

Report message to a moderator

Re: DBA_REGISTRY_HISTORY is not in database [message #437917 is a reply to message #437903]

Wed, 06 January 2010 09:08

Michel Cadot
Messages: 68712
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

DBA_REGISTRY% views were introduced in 10g.

Regards
Michel

Report message to a moderator

Re: DBA_REGISTRY_HISTORY is not in database [message #437923 is a reply to message #437903]

Wed, 06 January 2010 09:15

samg4ug
Messages: 33
Registered: July 2007
Location: India

Member

Hi,

Thanks a lot.

Is it even not existing in 9.2.0.8. Actually it comes under vulnerability during audit.

Regards,
Sam G

[Updated on: Wed, 06 January 2010 09:18]

Report message to a moderator

Re: DBA_REGISTRY_HISTORY is not in database [message #437943 is a reply to message #437923]

Wed, 06 January 2010 10:01

Michel Cadot
Messages: 68712
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

They exist in 9.2.0.8:

v920> select view_name from dba_views where view_name like 'DBA_REGISTRY%';
VIEW_NAME
------------------------------
DBA_REGISTRY
DBA_REGISTRY_HIERARCHY
DBA_REGISTRY_HISTORY

3 rows selected.

v920> @v

Version Oracle : 9.2.0.8.0

What do you mean by

Quote:

Actually it comes under vulnerability during audit.

Regards
Michel

[Updated on: Wed, 06 January 2010 10:01]

Report message to a moderator

Previous Topic:	Privileges on create procedure
Next Topic:	sql_text in dba_audit_trail is not populating

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 13 01:06:05 CST 2024