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'