can't drop synonym -- am I overlooking the obvious?

From: Ed Stevens <spamdump_at_nospam.noway.nohow>
Date: Thu, 11 Jul 2002 20:34:39 GMT
Message-ID: <3d2de9a1.84093049@ausnews.austin.ibm.com>

Platform: Oracle 8.0.5 on NT 4

SQL> select owner, synonym_name from dba_synonyms where SYNONYM_NAME like
'SY_SCRTY_USER_PROFIL%';

OWNER                          SYNONYM_NAME

------------------------------ ------------------------------

NMM                            SY_SCRTY_USER_PROFILE

SQL> drop synonym NMM.SY_SCRTY_USER_PROFILE; drop synonym NMM.SY_SCRTY_USER_PROFILE

                 *

ERROR at line 1:
ORA-01434: private synonym to be dropped does not exist

SQL> drop public synonym NMM.SY_SCRTY_USER_PROFILE   2 ;
drop public synonym NMM.SY_SCRTY_USER_PROFILE *
ERROR at line 1:
ORA-00995: missing or invalid synonym identifier

SQL> select '[' || SYNONYM_NAME || ']' from dba_synonyms where SYNONYM_NAME like
'SY_SCRTY_USER_PROFIL%';

'['||SYNONYM_NAME||']'

---

[SY_SCRTY_USER_PROFILE ] It appears that the synonym name has a trailing space in it!?!?! How do I drop this beast?

--
Ed Stevens
(Opinions expressed do not necessarily represent those of my employer.)

Received on Thu Jul 11 2002 - 15:34:39 CDT