ORA-01886
use CREATE PUBLIC SYNONYM statement to create a public synonym
Cause
An attempt was made to create a public synonym by issuing a CREATE SYNONYM statement naming PUBLIC as the name of the schema to which the synonym belongs.
Action
Either specify a valid schema for the synonym or use a CREATE PUBLIC SYNONYM statement.