(wrong string) ‚€™s status to VALID

From: Mark D Powell <Mark.Powell2_at_hp.com>
Date: Fri, 21 May 2010 06:57:36 -0700 (PDT)
Message-ID: <6bc24780-b6ae-477f-8c17-36dab295a889_at_c11g2000vbe.googlegroups.com>



On May 21, 4:56†am, "Vladimir M. Zakharychev" <vladimir.zakharyc..._at_gmail.com> wrote:
> 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

I do not currently have an 11g install I can access however in past versions the $ORACLE_HOME/rdbms/admin/cataudit.sql script contained the view definition. Have you tried rerunning this script?

HTH -- Mark D Powell -- Received on Fri May 21 2010 - 08:57:36 CDT

Original text of this message