查询时用表名代替用户名.表名

select 'create synonym '||table_name||' for userName.'||table_name||';' from dba_tables where owner='USERNAME'