HPE Community
Operating System - HP-UX
1856369 Members
8032 Online
104112 Solutions
New Discussion

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

 
ngaya_2
Occasional Contributor

‎05-03-2004 02:48 AM

‎05-03-2004 02:48 AM

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 .
0 Kudos
Reply
2 REPLIES 2
Brian Crabtree
Honored Contributor

‎05-03-2004 03:54 PM

‎05-03-2004 03:54 PM

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

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

Thanks,

Brian
0 Kudos
Reply
T G Manikandan
Honored Contributor

‎05-03-2004 04:04 PM

‎05-03-2004 04:04 PM

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
0 Kudos
Reply
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.