Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: can't drop synonym -- am I overlooking the obvious?

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

From: Terry Dykstra <dontreply_tddykstra_at_forestoil.ca>
Date: Thu, 11 Jul 2002 21:31:44 GMT
Message-ID: <4PmX8.6167$kt5.227877@news1.telusplanet.net>


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

> 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:31:44 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US