Printable View
Hello,
A user run the "Catproc.sql" script on a development box, and since then we get the "Ora-00980 Synonym translation is no longer valid" when we use OEM to check storage>Tablespace or datafiles? What has changed? What are the synonyms OEM is looking for that seemed dropped or moved?
How can we fix it?
Oracle enterprise 9.2.0.1.0
Windows 2000 Adv. Server
Re-run the same script as sysdba but no changes, we still have the error.
Thanks,
May be a bug.Try installing the patch 9.2.0.5.
Hi hun...
Maybe u can try to check all the invalid objects where object type
='SYNONYM' or
you can select count from all the synonyms to hit those invalid ones (select 'select count(*) from '||owner||'.'||synonym_name||';' from
sys.dba_synonyms;)
Then recreate it
errrr ummm WTF??Quote:
Originally posted by kris123
Hi hun...
Anyway.... If you run utlrp.sql it will compile all invalids for you. Also, just out of curiosity why would any DBA in their right mind let ANYONE run Catproc???
Thanks for all that replied, run the script still no changes? does this means it could have been dropped? if so what am I seaching for if I can't recover?