HPE Community
Operating System - HP-UX
1752815 Members
6183 Online
108789 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.