DBMS_AW_UTILITIES synonym invalid
Hi Guys
I have recently upgraded database from 10.2.0.3.0 to 10..2.0.4.0 on windows 2003 64 bit server. I fired the following query for invalid synonyms
select * from dba_synonyms s
where table_owner not in('SYSTEM','SYS')
and db_link is null
and not exists
(select 1
from dba_objects o
where s.table_owner=o.owner
and s.table_name=o.object_name)
order by owner;
and I got the following.
OWNER SYNOBYM_NAME TABLE_OWNER TABLE_NAME
PUBLIC DBMS_AW_UTILITIES OLAPSYS DBMS_AW_UTILITIES
PUBLIC SDO_AVAILABLE_ELEM_OPS MDSYS SDO_AVAILABLE_ELEMENTARY_OPS
There are other invalid user synonyms as well but my concern is related to above ones. Any idea how to compile them guys...