1-- Can be a table, package, procedure...
2CREATE OR REPLACE SYNONYM syn_name FOR my_schema.my_procedure;
3CREATE OR REPLACE PUBLIC SYNONYM syn_name FOR my_schema.my_procedure;
4
5-- Through a dblink:
6CREATE OR REPLACE SYNONYM syn_name FOR my_schema.my_procedure@my_dblink;