Oracle Database Discussions

Hi ,

I'm unable to fetch the rows from X$DBGALERTEXT , getting ORA-00942: table or view does not exist.

please guide me what exact permission needs to be granted to that particuar user...? DB is oracle 11g R2

Thanks.




select substr(MESSAGE_TEXT, 1, 300) message_text, count(*) cnt
from X$DBGALERTEXT
where (MESSAGE_TEXT like '%ORA-%' or upper(MESSAGE_TEXT) like '%ERROR%')
-- and cast(ORIGINATING_TIMESTAMP as DATE) > sysdate - #FREQUENCY#/1440
group by substr(MESSAGE_TEXT, 1, 300);

Edited by: Oragg on Mar 1, 2012 4:11 PM