I had to delete synonyms names from my set up in order to execute impdb command. Now please look at the following responses from SQL
| SQL> drop | public synonym /1000e8d1_LinkedHashMapValueIt; |
| drop | public synonym /1000e8d1_LinkedHashMapValueIt |
| | * |
ERROR at line 1:
ORA-00995: missing or invalid synonym identifier
(Question) the synonym name /1000e8d1_LinkedHashMapValueIt is perfectly valid synonym name as found out from the following query but i am not able to delete it. How can i delete this synonym just like any other normal synonym name??. Please help
SQL> select synonym_name from all_synonyms;
SYNONYM_NAME
------------------------------
CLIENT
/1000e8d1_LinkedHashMapValueIt
/1005bd30_LnkdConstant
/10076b23_OraCustomDatumClosur