Hi beloved Friends,

I am now migrating my 8.1.7(aix 4.3.3) database to
10g(10.1.0.3) AIX 5L.
One thing good about OEM 10g is that it warns me that I still have
invalid objects in my database,(even after running the pupbld.sql as
what the patch installer advised) in the monitor screen it says I have
6 objects are invalid in the PUBLIC schema and 14 objects are invalid
in the SYS schema. But when I select count(*) from dba_objects where
status='INVALID' i got a total of 61 objects. Why is this so?

I tried recompiling the object for PUBLIC and SYS:

SQL> alter SYNONYM PUBLIC.ALL_REPGROUPED_COLUMN compile;
alter SYNONYM PUBLIC.ALL_REPGROUPED_COLUMN compile
*
ERROR at line 1:
ORA-00995: missing or invalid synonym identifier
=============================================================
How do I compile a public object?
=============================================================
SQL> alter VIEW SYS._ALL_REPGROUPED_COLUMN compile;
alter VIEW SYS._ALL_REPGROUPED_COLUMN compile
*
ERROR at line 1:
ORA-00911: invalid character
=============================================================
How do I compile an object with a leading "_" name?
=============================================================
SQL> alter PACKAGE BODY SYS.DBMS_SQLTUNE compile;
alter PACKAGE BODY SYS.DBMS_SQLTUNE compile
*
ERROR at line 1:
ORA-00922: missing or invalid option
=============================================================
How do I compile a package body?
=============================================================


Thanks a lot in avance

Ms Congeniality III