The problem is that the synonym is invalid because it is queried by the table's synonym, and this table cannot be found, so the synonym is invalid.
Analyze the reason, when we create synonyms, the system will not detect the existence of the original table. However, this error occurs when you manipulate the table with this synonym.
Problem possibility:
1. Whether the current schema has permission to use the synonym
2. Does the table exist
Ask Tom:
that error simply means "synonym is Still here, but the object it points to is inaccessible ". it could are in Accessible due to a missing grant, or due to the object not being there. you need to find out what synonym it was, query the data dictionary to figure out what ; object it points to and figure out why you no longer has access to that object.
[email protected]> create synonym s for t;
Synonym created.
[Email protected]> select * from S where rownum = 1;
C
----------
1
[Email protected]> drop table t;
Table dropped.
[Email protected]> select * from S where rownum = 1;
SELECT * from S where rownum = 1
ERROR at line 1:
ora-00980:synonym translation is no longer valid
ora-00980:synonym translation is no longer valid