(wrong string) ’s status to VALID

From: zigzagdna <zigzagdna_at_yahoo.com>
Date: Thu, 20 May 2010 20:54:12 -0700 (PDT)
Message-ID: <f0f7158f-256a-4ac8-8f70-c6f478fef543_at_a16g2000vbr.googlegroups.com>



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. Received on Thu May 20 2010 - 22:54:12 CDT

Original text of this message