-
Ora-00980
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
-
Originally posted by kris123
Hi hun...
errrr ummm WTF??
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?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|