topic ora-00942 error in Operating System - HP-UX

ora-00942 error

ngaya_2 — Wed, 05 May 2004 03:15:35 GMT

hi,
when i lauch the command follow:
alter view dba_audit_session compile;
select text from dba_errors where name = 'DBA_AUDIT_SESSION';

i had the error message:
ora-00942: table or view does not exist.

how i can to do for to resolv this probleme.
please help me.
thanks.

Re: ora-00942 error

G. Vrijhoeven — Wed, 05 May 2004 03:19:16 GMT

Hi,

Does the view/table exist?

Gideon

Re: ora-00942 error

Jean-Luc Oudart — Wed, 05 May 2004 05:42:33 GMT

Hi,

1) which user do you use to compile this object

2) Could you run this query :
select * from dba_objects where object_name='DBA_AUDIT_SESSION'

Regards,
Jean-Luc

Re: ora-00942 error

Joseph Loo — Wed, 05 May 2004 05:48:57 GMT

hi,

this view is from the sys schema, unless you are logon as system or granted rights to the view, else the error will always occurs.

regards.

Re: ora-00942 error

Brian Crabtree — Wed, 05 May 2004 14:36:10 GMT

Ngaya,

What user are you connected as (should be sys or system)?

What version of Oracle are you using?

Also, you have been opening a new thread each time you post. It would be easier if you posted everything in one thread, so that we can see it easier, and not have to trace back through a number of different threads on the same issue.

Thanks,

Brian