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

On Thu, 11 Jul 2002 20:34:39 GMT, spamdump_at_nospam.noway.nohow (Ed Stevens) wrote:

>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?

 drop synonym NMM."SY_SCRTY_USER_PROFILE ";

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Jul 11 2002 - 16:44:01 CDT