下面是一个简单的同义词测试,分两种情况:
1、同义词与指向对象名称不同
SQL> create public synonym t_synonym2 for nbudata.t_synonym22; --nbudata.t_synonym22对象并不存在
Synonym created
SQL> select * from t_synonym2;
select * from t_synonym2
ORA-00980: 同义词转换不再有效
SQL> select * from t_synonym2;
select * from t_synonym2
ORA-00980: 同义词转换不再有效
SQL> select * from dba_synonyms where synonym_name =upper('t_synonym2');
OWNER SYNONYM_NAME TABLE_OWNER TABLE_NAME DB_LINK
-------------------- ------------------------------ ------------------------------ ------------------------------ ---------
PUBLIC T_SYNONYM NBUDATA T_SYNONYM
SQL> select owner, object_name, object_type, status from dba_objects where object_name