Re: Alter synonym ?

Not possible. Put the drop and create back to back separated by a ';' . The synonym will be missing for a milli-second or two.

"gatorade" <Gatorade_at_free.fr> wrote in message news:f6a787b3.0205040438.676f1804_at_posting.google.com...
> Hello,
> How can I modify a synonym without dropping it ?
>
> Is it possible to change it via system table
> like "dba_synonym" ?
>
> Does anyone have an other solution ?
>
>
> Description of my problem
> -------------------------
> how to modify a package in production without stopping the
> site and offcours withoutany impact
> during the switch bewteen old and new package
>
>
> A is a synonym for the package A1
> I want to switch the package A1 with A2
> in order to put the package A2 in production
> instead of the package A1 without stopping our
> web site.
> The problem is that I have to drop the synonym
> and recreate it because alter synonyme is not supported.
>
> Ideas are welcome.
>
> bye.
Received on Sun May 05 2002 - 21:16:23 CEST