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

Ed:

Try:

drop public synonym SY_SCRTY_USER_PROFILE

I don't believe you should qualify the PUBLIC synonym with an owner name.

Hope this helps.
Tom Best

"Ed Stevens" <spamdump_at_nospam.noway.nohow> wrote in message news:3d2de9a1.84093049_at_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 - 16:03:52 CDT