clicksor ad

Friday, October 13, 2006

ORA-00980: synonym translation is no longer valid

SQL>create table maintab as select * from tab;

Table created.

SQL> create synonym syn_maintab for maintab;

Synonym created.

SQL> select * from syn_maintab;

TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
AAAAA


10 rows selected.

SQL> drop table maintab;

Table dropped.

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

The grants to the table or the table itself is no longer avaialble.Please check the same

No comments: