How ORA-00980 solves

ORA-00980: synonymtranslationisnolongervalid, ORA-00980: synonym conversion no longer valid

ORA-00980: synonym translation is no longer valid, ORA-00980: synonym conversion no longer valid

ORA-00980: synonym translation is no longer valid

ORA-00980: synonym conversion is no longer valid

Master TOM explained the error :? P = 100: 11: 0: P11_QUESTION_ID: 7095288486502

That means you lost some object/access to some object when you did your move. That error
Simply means "synonym is still here, but the object it points to is inaccessible". It
Cocould be inaccessible due to a missing grant, or due to the object not being there.

You need to find out what synonym it is, query the data dictionary to figure out what
Object it points to and figure out why you no longer have access to that object.

Ops $ tkyte @ ORA920> create synonym s for t;
Synonym created.

Ops $ tkyte @ ORA920> select * from s where rownum = 1;

C
----------
1

Ops $ tkyte @ ORA920> drop table t;
Table dropped.

Ops $ tkyte @ ORA920> select * from s where rownum = 1;
Select * from s where rownum = 1
*
ERROR at line 1:
ORA-00980: synonym translation is no longer valid

Ops $ tkyte % ORA11GR2>! Oerr ora 980.
00980,000 00, "synonym translation is no longer valid"
// * Cause: A synonym did not translate to a legal target object. This
// Cocould happen for one of the following reasons:
// 1. The target schema does not exist.
// 2. The target object does not exist.
// 3. The synonym specifies an incorrect database link.
// 4. The synonym is not versioned but specifies a versioned
// Target object.
// * Action: Change the synonym definition so that the synonym points
// A legal target object.

Query dba_objects and dba_users to see if there is another object/schema out there that overlaps the namespace please.

All in all, TOM means that the synonym has expired. For more information about the reasons for failure, see the above explanation.

The ORA-00980 synonym translation is no longer valid error occurred when I was using DBlink. I am very confused. If you know more, please let me know. Thank you!
Situation:
1) write the SQL statement insert into table (...) in PL/SQL (.....) select .... from view @ dblink is normal, and data can be inserted.
2) After writing the above SQL in Procedure, the compilation times an error, the ORA-00980 synonym translation is no longer valid.
3) I create a view in the local database, create or replace view XXX as select... from view @ dblink.
4) the SQL statement in procedure is modified to insert into table (...) select... from XXX, which can be compiled successfully.

Why? Can't dblink be used to read views in procedure?

I created an intermediate view to solve the problem of 00980 error during compilation. If you have a better solution, please let us know. Thank you!