error-04063: view sys.dba_audit_session has errors

[ngaya_2]

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.

[G. Vrijhoeven]

Hi,

You could check this link:

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

HTH,

Gideon

[Brian Crabtree]

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