由于owner='PUBLIC',所以在用数据泵导入的时候不会被导入,需要手动创建。将查询结果在目标端数据库中执行
SELECT 'CREATE or replace PUBLIC SYNONYM '||synonym_name||' FOR '||table_owner||'.'||table_name||';' FROM DBA_SYNONYMS WHERE table_owner in ('AAA','BBB','CCC','DDD','EEE','FFF','GGG') AND owner='PUBLIC';
其中('AAA','BBB','CCC','DDD','EEE','FFF','GGG')为查询的用户名