Dear Friends,
Please see the following, when I trying to recompile invalid objects I got it.
SQL> select owner, table_name
from dba_tables
where tablespace_name = 'SYSTEM'
and owner not in ('SYS', 'SYSTEM'); 2 3 4
OWNER TABLE_NAME
------------------------------ ------------------------------
OUTLN OL$
OUTLN OL$HINTS
OUTLN OL$NODES
SQL> select obj#, compile_err from utl_recomp_errors;
OBJ#
----------
COMPILE_ERR
--------------------------------------------------------------------------------
73037
ORA-04045: errors during recompilation/revalidation of PUBLIC.QUEST_COM_PRODUCTS
_USED_BY
ORA-00980: synonym translation is no longer valid
73039
ORA-04045: errors during recompilation/revalidation of PUBLIC.QUEST_COM_PRODUCT_
PRIVS
ORA-00980: synonym translation is no longer valid
OBJ#
----------
COMPILE_ERR
--------------------------------------------------------------------------------
73041
ORA-04045: errors during recompilation/revalidation of PUBLIC.QUEST_COM_USERS
ORA-00980: synonym translation is no longer valid
73043
ORA-04045: errors during recompilation/revalidation of PUBLIC.QUEST_COM_USER_PRI
VILEGES
ORA-00980: synonym translation is no longer valid
OBJ#
----------
COMPILE_ERR
--------------------------------------------------------------------------------
73045
ORA-04045: errors during recompilation/revalidation of PUBLIC.QUEST_COM_PRODUCTS
ORA-00980: synonym translation is no longer valid
Thanks in advance..
Best Regards,