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

From: Ed Stevens <spamdump_at_nospam.noway.nohow>
Date: Fri, 12 Jul 2002 12:17:05 GMT
Message-ID: <3d2ec899.1382998@ausnews.austin.ibm.com>

On Thu, 11 Jul 2002 23:44:01 +0200, Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote:

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

THAT one worked! Thanks!

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

Received on Fri Jul 12 2002 - 07:17:05 CDT

This message: [ Message body ]
Next message: Rolf Sapler: "explanation of parameters in ini<sid>.ora"
Previous message: Mike Ault: "Re: How to confirm someone is an OCP?"
In reply to: Sybrand Bakker: "Re: can't drop synonym -- am I overlooking the obvious?"
Next in thread: Tom Best: "Re: can't drop synonym -- am I overlooking the obvious?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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