OCI-01888
use DROP PUBLIC SYNONYM statement to drop a public synonym
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.