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
Click Here to Expand Forum to Full Width