SQL> create synonym emp for scott.emp;

Synonym created.

SQL>

SQL> spool fahim.sql
SQL> set serveroutput on;
SQL> declare
  2    l_str varchar2(200);
  3  begin
  4    for cur_r in (select table_name from user_tables) loop
  5      l_str := 'create synonym ' || cur_r.table_name || ' for scott.' || cur_r.table_name ||';';
  6      dbms_output.put_line(l_str);
  7    end loop;
  8  end;
  9  /
create synonym STAFF for scott.STAFF;
create synonym TEST for scott.TEST;
create synonym HOSPITAL_WARDS for scott.HOSPITAL_WARDS;
create synonym HOSPITAL_BEDS for scott.HOSPITAL_BEDS;
create synonym MASTER for scott.MASTER;
create synonym TABLEA for scott.TABLEA;
create synonym TABLEB for scott.TABLEB;
<snip>
create synonym BUY for scott.BUY;
create synonym RENT for scott.RENT;

PL/SQL procedure successfully completed.

SQL> spool off
SQL>