CODE EXAMPLE FOR SQL

create synonym for dblink in oracle

-- Can be a table, package, procedure...
CREATE OR REPLACE SYNONYM syn_name FOR my_schema.my_table@my_dblink;
CREATE OR REPLACE SYNONYM syn_name FOR my_schema.my_procedure@my_dblink;
CREATE OR REPLACE SYNONYM syn_name FOR my_schema.my_package@my_dblink;