SQL & PL/SQL

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!

ORA-00980: synonym translation is no longer valid

msDec 17 2010 — edited Dec 18 2010

Hello Everyone

I'm using oracle 11g database,windows xp. I have created a table in scott and given grant create synonym as sysdba/scott.I have given synonym and grant rights from scott ( as sysdba ) to system db. But when i query the particular table from system db i get the error ORA-00980: synonym translation is no longer valid. But i'm able to query the table by appending SCOTT.table name. Could you pls sugest how to solve this problem.

Thanks
Gautam

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 15 2011

Added on Dec 17 2010

3 comments

719 views