ora-00942 error

[ngaya_2]

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.

[G. Vrijhoeven]

Hi,

Does the view/table exist?

Gideon

[Jean-Luc Oudart]

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

[Joseph Loo]

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.

[Brian Crabtree]

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