(wrong string) ‚€™s status to VALID
Date: Fri, 21 May 2010 01:56:40 -0700 (PDT)
On May 21, 7:54†am, zigzagdna <zigzag..._at_yahoo.com> wrote:
> I am on Oracle 11g 18.104.22.168.1 on HP UNIX 11i. I have run utilrp.sql
> yet I see
> DBA_AUIT_TRAIL is INVALID
> When I try to recompile DBA_AUIT_TRAIL it errors out with a message:
> SQL> show errors view DBA_AUDIT_TRAIL;
> Errors for VIEW DBA_AUDIT_TRAIL:
> 0/0 † † †ORA-00904: "OBJ$EDITION": invalid identifier
> So where is OBJ$EDITON; † how to make this view valid.
Huh? Edition-Based Redefinition is a new feature in 11g Release 2, isn't it? OBJ$EDITION seems to be related to this feature, it shouldn't be present in 11.1 (at least, not officially.) You probably installed a backport patch that should not had been installed or they backported it wrong.
Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm) http://www.dynamicpsp.com Received on Fri May 21 2010 - 03:56:40 CDT