invalid objects after migration 8i to 10g

[kris123]

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

[reydp]

alter package body OWNER.object_name compile body;

synonyms doesn't have to be compile, check with its
previous existense.

But when I select count(*) from dba_objects where status='INVALID' i got a total of 61 objects. Why is this so?

'cause dba_objects includes all schemas.

[kris123]

yes dear, all i have selectd are from PUBLIC and SYS only ...well i just got 1 from my user schema.
I keep on recompiling the SYS objects and it did successfully. but when i check it theres another gets invalid like domino effect.

Thanks a lot

Ms Congeniality III

[davey23uk]

public isnt a user, it doesnt own any objects so nothing to compile.

Run @?/rdbms/admin/utlrp to do the invalid objects