The Oracle CREATE SYNONYM statement creates an alternative name for objects such as tables, views, sequences, stored procedures, and other database objects.
The general format is:
CREATE [OR REPLACE] [PUBLIC] SYNONYM [schema.]synonym FOR [schema.]object[@dblink]
Example 1:
CREATE PUBLIC SYNONYM invoice FOR app.invoice;