public synonyms [message #192902] |
Thu, 14 September 2006 03:13 |
maoro
Messages: 312 Registered: May 2005
|
Senior Member |
|
|
hello i have 2 oracle applications on a 10G server on winxp,
the first application is owned by user s1,
the second is owned by user s2,
the problem is that when i imported the second schema into user s2 there was some public synonyms with the same names as the ones used by the first application,
i dont have access to the application code,
is there any way to solve it ?
thanks alot
|
|
|
|
Re: public synonyms [message #192984 is a reply to message #192954] |
Thu, 14 September 2006 08:45 |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
goudelly wrote on Thu, 14 September 2006 07:36 | If you are importing the data to usr2 it will over write the public synonyms.
|
False.
|
|
|
Re: public synonyms [message #192987 is a reply to message #192902] |
Thu, 14 September 2006 08:50 |
Liza79
Messages: 74 Registered: September 2006
|
Member |
|
|
you are in a trouble now.
The import does not overwrite's it actually does not do anything with the objects which xists already. SO both the applications will start using the same synonyms.
i have just one solution in my mind right now, that is to stop using public synonyms and create local synonyms for every user. A script can be created that is run every time a new user is created.
hmmmmm....don't know suits you or not.
|
|
|
Re: public synonyms [message #192995 is a reply to message #192902] |
Thu, 14 September 2006 09:15 |
maoro
Messages: 312 Registered: May 2005
|
Senior Member |
|
|
Dear miss liza
thanks for your continious help
the problem is that both applications reference synonyms with the same names, i dont have access to the application code,
and if i create sysnonyms as private then i have to qualify them inside the appication like hr.sy_name, and again no access to application code
is there any way ??
thanks
|
|
|
Re: public synonyms [message #193014 is a reply to message #192902] |
Thu, 14 September 2006 09:47 |
maoro
Messages: 312 Registered: May 2005
|
Senior Member |
|
|
thanks a lot
i got it,it works cause private synonyms take precedence over the public ones, but then i have to create a different set of users for the second application along with their private synonyms,
merci
|
|
|