本人在开发过程中遇到以下问题:
解决办法:
OWNER SYNONYM_NAME TABLE_OWNER TABLE_NAME DB_LINK
SNSMANAGER US_USERINFORMATION SNSMANGER US_USERINFORMATION EBOOK.TESTDBA
SNSMANAGER MCP_AUTHORINFORMATION SNSMANGER MCP_AUTHORINFORMATION EBOOK.TESTDBA
--1、检查语句
select * from all_synonyms WHERE owner = 'SNSMANAGER' AND DB_LINK LIKE 'EBOOK%' and table_owner = 'SNSMANGER';
--2、重建语句
create or replace synonym SNSMANAGER.US_FLOOR_NUM for MREAD.US_FLOOR_NUM@ebook;