we accessing remote data by using dblinks and we create a synonyms by using db links.
i am using synonym in database trigger.Which is used for some remote database table
trans actions.I was created all synonyms which
are using remote tables in triggers.I get a error.
any one help me
ORA-00980 synonym translation is no longer valid
Cause: The synonym used is based on a table, view, or synonym that no longer exists.
Action: Replace the synonym with the name of the object it references or re-create the synonym so that it refers to a valid table, view, or synonym.
I was created synonym and dblinks
Looks like somebody has renamed the table. Please check that.
Synonym will get invalid anytime a base object or the object it references is ALTERED.
So in addition to checking the Tables being altered, also check if your trigger is calling any other trigger or procedure and if that has been invalidated.
Click Here to Expand Forum to Full Width