Tuesday, December 11, 2007

ORA-00980: synonym translation is no longer valid

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.

This problem can come when you make an operation on a synonym that has no base object.
for retification this problem you can recreate synonym with proper base object.

No comments: