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
Thursday, January 1, 2009
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment