Cause
An attempt was made to drop a public synonym by issuing a DROP SYNONYM statement naming PUBLIC as the name of the schema to which the synonym belongs.
Action
Use a DROP PUBLIC SYNONYM statement to drop a public synonym.
Oracle 26ai
ORA-01888
Error Message
use DROP PUBLIC SYNONYM statement to drop a public synonym