Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ORA-00980: Synonym Translation Is No Longer Valid

user8922278Jul 25 2011 — edited Jul 25 2011

Hi everybody,

I encounter the error message ORA-00980: Synonym Translation Is No Longer Valid while any user, that is not having the Admin Profile, clicks on the SAVE Button.
At first, I tried to see if there was an error in profiling, and after some tests, I found that this problem is encountered by all users but the Admin one.
After some researches in Internet, I thought that a recreation of all synonyms will solve the problem. Not mine !! Because I recreated the synonyms for all tables used in a module (where I encounter the error message) but nothing has changed.
Is there a way of knowing all the synonyms created in my program and are no longer valid?

Many Thanks.

Regards

..IQAN..

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 22 2011

Added on Jul 25 2011

#general-database-discussions

5 comments

1,660 views