create database link db_link_name
connect to <username> identified by <pwd>
using 'SERVICE_NAME';

HGC =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.9)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = oramfe)
    )
  )

SQL> show user
USER is "TAJ"
SQL> create table test1 as select * from all_objects;

Table created.

SQL> alter user scott account unlock;

User altered.

SQL> grant select , insert, update , delete on TEST1 to SCOTT;

Grant succeeded.

SQL> conn scott/tiger
Connected.
SQL> create synonym taj_test1 for TAJ.TEST1;

Synonym created.

SQL> create table test1 as select * from taj_test1;

Table created.

SQL> conn taj/taj
Connected.
SQL> drop table test1;

Table dropped.

SQL> select count(*) from SCOTT.TAJ_TEST1;
select count(*) from SCOTT.TAJ_TEST1
                           *
ERROR at line 1:
ORA-00980: synonym translation is no longer valid


SQL> create table test1 as select * from all_objects;

Table created.

SQL> select count(*) from SCOTT.TAJ_TEST1;

  COUNT(*)
----------
     47570