ORA-01887
use ALTER PUBLIC SYNONYM statement to alter a public synonym
Cause
An attempt was made to alter a public synonym by issuing an ALTER SYNONYM statement naming PUBLIC as the name of the schema to which the synonym belongs.
Action
Use an ALTER PUBLIC SYNONYM statement to alter a public synonym.