Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

error-04063: view sys.dba_audit_session has errors

ngaya_2
Occasional Contributor

error-04063: view sys.dba_audit_session has errors

hello,
thank you for your assistance.
actually, i rerun the script $ORACLE_HOME/rdbms/admin/cataudit.sql but i have the same error error-04063: view sys.dba_audit_session has errors.
please, help me. thanks.
2 REPLIES
G. Vrijhoeven
Honored Contributor

Re: error-04063: view sys.dba_audit_session has errors

Hi,

You could check this link:

http://forums.devshed.com/archive/t-72626

HTH,

Gideon

Brian Crabtree
Honored Contributor

Re: error-04063: view sys.dba_audit_session has errors

Hmmm.

Try this as SYS or internal:

alter view dba_audit_session compile;
select text from dba_errors where name = 'DBA_AUDIT_SESSION';

The compile should fail, but I am more interested in the errors. Please post them back (or if there isn't anything listed.

Thanks,

Brian