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:
Post a Comment