ORA-01432
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.
Solutions
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%';
SYNONYM_NAME
----------------
COUNTRIES
Then we correct the name in the statement.
SQL> drop public synonym countries;
Synonym dropped.
We solved it.