Thursday, January 1, 2009

ORA-00980: synonym translation is no longer valid

SQL>create table release as select * from tab;

Table created.

SQL> create synonym s_release for release;

Synonym created.

SQL> select * from s_release;

TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
ATT TABLE
BONUS TABLE
CAR TABLE
DEPT TABLE
DUMMY TABLE
EMP TABLE
PLAN_TABLE TABLE
RELEASE TABLE
SALGRADE TABLE
TWIST TABLE

10 rows selected.

SQL> drop table release;

Table dropped.

SQL> select * from s_release;
select * from s_release
*
ERROR at line 1:
ORA-00980: synonym translation is no longer valid

No comments:

Post a Comment