Dropper les synonymes :

SELECT 'DROP SYNONYM ', synonym_name, ';' FROM user_synonyms;