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 18.104.22.168.0
Windows 2000 Adv. Server
Re-run the same script as sysdba but no changes, we still have the error.
May be a bug.Try installing the patch 22.214.171.124.
Maybe u can try to check all the invalid objects where object type
you can select count from all the synonyms to hit those invalid ones (select 'select count(*) from '||owner||'.'||synonym_name||';' from
Then recreate it
errrr ummm WTF??
Originally posted by kris123
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???
Oracle it's not just a database it's a lifestyle!
BTW....You need to get a girlfriend who's last name isn't .jpg
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?
Click Here to Expand Forum to Full Width