Warning: View altered with compilation errors

From: zigzagdna <zigzagdna_at_yahoo.com>
Date: Fri, 26 Mar 2010 12:14:09 -0700 (PDT)
Message-ID: <a3bc1c01-07a1-4bd9-b73b-db16bae51051_at_i25g2000yqm.googlegroups.com>



I am using 10.2.0.3 on HP UNIX 11i. I got some warning when I did import data pump. But when I tried to start compiling objects, I do not see any error messages in show errors, why?

SQL> alter view TW_RPT_4232 compile;

Warning: View altered with compilation errors.

SQL> show errors;
No errors.
SQL> Received on Fri Mar 26 2010 - 14:14:09 CDT

Original text of this message