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

hi,
i have oracle 8.1.7 installed on hp 11.
when i want to lauch a command sql follow:
select * from dba_audit_session;
i receive the error:
error-04063: view sys.dba_audit_session has errors

how i can to reolve it ?.
thank for your assistance .
2 REPLIES
Brian Crabtree
Honored Contributor

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

Re-run $ORACLE_HOME/rdbms/admin/cataudit.sql

Thanks,

Brian
T G Manikandan
Honored Contributor

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

yes,the audit views are not initialized properly.Re-run

svrmgr>@$ORACLE_HOME/rdbms/admin/cataudit


REvert on results