Tried to drop a public synonym, but it failed with ORA-01432.
SQL> drop public synonym country;
drop public synonym country
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist
ORA-01432 means that the public synonym you specified in the statement is not found, so it cannot be drop in this moment. Most likely, you misspelled the name.
First of all, we should check what name it should be.
SQL> column synonym_name format a16;
SQL> select synonym_name from all_synonyms where owner = 'PUBLIC' and synonym_name like 'COUN%';
Then we correct the name in the statement.
SQL> drop public synonym countries;
We solved it.