1. 创建同义词
CREATE OR REPLACE SYNONYM "username1"."table_name" FOR "username2"."table_name";
2. 批量创建同义词
生成批量脚本
select 'CREATE OR REPLACE SYNONYM "username1"."'||TABLE_NAME||'" FOR "username2"."'||TABLE_NAME||'";'
from user_tab_comments where table_type='TABLE';