Hi,

Remove the global name "us.oracle.com" from the db link name.

Please notice the following example:


SQL> create synonym disco1.DB_LNK.ORACLE.COM for scott.DB_LNK.ORACLE.COM;
create synonym disco1.DB_LNK.ORACLE.COM for scott.DB_LNK.ORACLE.COM
*
ERROR at line 1:
ORA-00905: missing keyword


SQL> create synonym disco1.DB_LNK for scott.DB_LNK;

Synonym created.


In addition,i don't understand why do you need to create a synonym for db link.

The using of db link in createing synonym is when you want to view a remote table. For example:

create database link db_lnk connect to user identified by pwd
using 'alias';

create synonym table1 for table1@db_lnk;

Regards,
Nir