cancel
Showing results for 
Search instead for 
Did you mean: 

ora-00942 error

ngaya_2
Occasional Contributor

ora-00942 error

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.
4 REPLIES
G. Vrijhoeven
Honored Contributor

Re: ora-00942 error

Hi,

Does the view/table exist?

Gideon
Jean-Luc Oudart
Honored Contributor

Re: ora-00942 error

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
fiat lux
Joseph Loo
Honored Contributor

Re: ora-00942 error

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.
what you do not see does not mean you should not believe
Brian Crabtree
Honored Contributor

Re: ora-00942 error

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