復制代碼 代碼如下:

SELECT * FROM B.TABLENAME。

復制代碼 代碼如下:

create synonym tablename for B.TABLENAME;

復制代碼 代碼如下:

drop synonym tablename ;

復制代碼 代碼如下:

select 'CREATE SYNONYM '||table_name||' FOR A.'||table_name from dba_tables where owner = 'A'