select 'CREATE OR REPLACE SYNONYM "username1"."'||TABLE_NAME||'" FOR "username2"."'||TABLE_NAME||'";'
from user_tab_comments where table_type='TABLE';

查询结果：CREATE OR REPLACE SYNONYM "username1"."table_name" FOR "username2"."table_name";