topic error-04063: view sys.dba_audit_session has errors in Operating System - HP-UX

error-04063: view sys.dba_audit_session has errors

ngaya_2 — Mon, 03 May 2004 09:48:50 GMT

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 .

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

Brian Crabtree — Mon, 03 May 2004 22:54:45 GMT

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

Thanks,

Brian

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

T G Manikandan — Mon, 03 May 2004 23:04:45 GMT

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

svrmgr>@$ORACLE_HOME/rdbms/admin/cataudit

REvert on results