Warning: View altered with compilation errors.
s9225May 27 2008 — edited May 27 2008Hi, All,
I found invalid objects,
SQL> select 'ALTER ' || OBJECT_TYPE || ' ' || owner || '.' || OBJECT_NAME || ' COMPILE;' from dba_objects where status = 'INVALID';
'ALTER'||OBJECT_TYPE||''||OWNER||'.'||OBJECT_NAME||'COMPILE;'
--------------------------------------------------------------------------------
ALTER VIEW ARADMIN.AM_CHECK_TECH COMPILE;
SQL> ALTER VIEW ARADMIN.AM_CHECK_TECH COMPILE;
Warning: View altered with compilation errors.
Any friends with any idea to check?
thanks a lot in advance.