Tags: database, databases, error, imported, imports, mysql, ora-980, oracle, oracle92, sql, synonym, translation, valid
ORA-980 SYNONYM TRANSLATION IS NO LONGER VALID
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 ',
from dba_synonyms s
where table_owner not in('SYSTEM','SYS')
and db_link is null
and not exists
from dba_objects o
and s.table_name=o.object_name) );
Any idea ?
Leave a comment...
- 0 Comments