Oracle Database Discussions

Hi ALL,

I have imported the data into two Oracle92 databases from Oracle92. All the imports went well but one of the database is giving me a error while accessing it from OEM ORA-980 SYNONYM TRANSLATION IS NO LONGER VALID when try to access any of the schema.


I cannot find where is the problem. I ran the following script on both the databases and its coming up with the same number of records. One of the database I am getting the error and the other one is running fine and shows no errors.

select count (*) from (select 'drop '||decode (s.owner,'PUBLIC','PUBLIC SYNONYM ',
'SYNONYM'||s.owner||'.')||s.synonym_name||';'
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) );

Any idea ???

Regards,