Home » RDBMS Server » Security » DBA_REGISTRY_HISTORY is not in database (Oracle 9.2.0.3/Windows 2003)
DBA_REGISTRY_HISTORY is not in database [message #437903] Wed, 06 January 2010 08:38 Go to next message
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
Re: DBA_REGISTRY_HISTORY is not in database [message #437908 is a reply to message #437903] Wed, 06 January 2010 08:52 Go to previous messageGo to next message
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
Re: DBA_REGISTRY_HISTORY is not in database [message #437917 is a reply to message #437903] Wed, 06 January 2010 09:08 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
DBA_REGISTRY% views were introduced in 10g.

Regards
Michel
Re: DBA_REGISTRY_HISTORY is not in database [message #437923 is a reply to message #437903] Wed, 06 January 2010 09:15 Go to previous messageGo to next message
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 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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:
  


Current Time: Fri Mar 29 07:39:07 CDT 2024