Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: can't drop synonym -- am I overlooking the obvious?
Use doublequotes:
drop synonym "SY_SCRTY_USER_PROFIL "
-- Terry Dykstra Canadian Forest Oil Ltd. "Ed Stevens" <spamdump_at_nospam.noway.nohow> wrote in message news:3d2de9a1.84093049_at_ausnews.austin.ibm.com...Received on Thu Jul 11 2002 - 16:31:44 CDT
> 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.)