OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Urgent Help

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

Urgent Help [message #62961]

Sun, 29 August 2004 21:04

Gunasekaran D
Messages: 11
Registered: August 2004

Junior Member

Hi,

when executing below queries system is saying "table or view does not exist", where i can find these table, they are not existing under sys.

GRANT SELECT ON SYS.DBA_BLOCKERS TO SELECT_CATALOG_ROLE
�� *
ERROR at line 1:
ORA-00942: table or view does not exist

GRANT SELECT ON SYS.DBA_DDL_LOCKS TO SELECT_CATALOG_ROLE
�� *
ERROR at line 1:
ORA-00942: table or view does not exist

GRANT SELECT ON SYS.DBA_DML_LOCKS TO SELECT_CATALOG_ROLE
�� *
ERROR at line 1:
ORA-00942: table or view does not exist

GRANT SELECT ON SYS.DBA_KGLLOCK TO SELECT_CATALOG_ROLE
�� *
ERROR at line 1:
ORA-00942: table or view does not exist

GRANT SELECT ON SYS.DBA_LOCK TO SELECT_CATALOG_ROLE
�� *
ERROR at line 1:
ORA-00942: table or view does not exist

�

�

Regards,

Guna

Report message to a moderator

Re: Urgent Help [message #62962 is a reply to message #62961]

Sun, 29 August 2004 21:32

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Those are created with the 'catblock.sql' script. The script can be found in the Oracle_home/rdbms/admin/ directory. Run the script as SYS.

They are optional, so it's not really that urgent...

MHE

Report message to a moderator