From: "Burt Peltier" Newsgroups: comp.databases.oracle References: Subject: Re: Alter synonym ? Lines: 34 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 Message-ID: X-Complaints-To: abuse@usenetserver.com X-Abuse-Info: Please be sure to forward a copy of ALL headers X-Abuse-Info: Otherwise we will be unable to process your complaint properly. NNTP-Posting-Date: Sun, 05 May 2002 14:42:56 EDT Organization: Bellsouth.Net Date: Sun, 5 May 2002 14:16:23 -0500 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" wrote in message news:f6a787b3.0205040438.676f1804@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.