- 不带dblink
select 'create or replace synonym '||SYNONYM_NAME||' for '|| TABLE_OWNER||'.'||TABLE_NAME||';'
from user_synonyms where table_owner is not null; - 带dblink
select 'create or replace synonym '||SYNONYM_NAME||' for '||TABLE_NAME||'@'||DB_LINK||';'
from user_synonyms where table_owner is null;