--------你把这个语句修改下,然后把查询的结果复制到plsql中,执行下就行了
Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 
Connected as tiny


SQL> 
SQL> select 'create synonym ' || table_name || ' for ' || owner || '.' ||
  2         table_name || ';'
  3    from all_tables
  4   where owner = upper('scott')
  5  ;

'CREATESYNONYM'||TABLE_NAME||'
--------------------------------------------
create synonym DEPT for SCOTT.DEPT;
create synonym EMP for SCOTT.EMP;
create synonym BONUS for SCOTT.BONUS;
create synonym SALGRADE for SCOTT.SALGRADE;
create synonym HIS_DEPT for SCOTT.HIS_DEPT;
create synonym INSTOCK for SCOTT.INSTOCK;

6 rows selected

SQL>

------解决方案--------------------
探讨

如果是这样，那岂不是 每张表都有一条语句？有没有批量的？

引用:
用lolo登陆
create table application as select *　from xzq.application

要不就在xzp下给application表建同义词