(wrong string) ’s status to VALID

From: Vladimir M. Zakharychev <vladimir.zakharychev_at_gmail.com>
Date: Fri, 21 May 2010 01:56:40 -0700 (PDT)
Message-ID: <1c3430cb-c108-4265-8c79-bec46d7eede2_at_f13g2000vbm.googlegroups.com>



On May 21, 7:54 am, zigzagdna <zigzag..._at_yahoo.com> wrote:
> I am on Oracle 11g 11.1.0.7.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
> SQL>
>
> 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.

Regards,

   Vladimir M. Zakharychev
   N-Networks, makers of Dynamic PSP(tm)    http://www.dynamicpsp.com Received on Fri May 21 2010 - 03:56:40 CDT

Original text of this message