Home -> Usenet -> comp.databases.oracle -> Alter synonym ?

Alter synonym ?

From: gatorade <Gatorade_at_free.fr>
Date: 4 May 2002 05:38:31 -0700
Message-ID: <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 Sat May 04 2002 - 14:38:31 CEST












Original text of this message