Home » RDBMS Server » Server Administration » public synonyms
public synonyms [message #192902] Thu, 14 September 2006 03:13 Go to next message
maoro
Messages: 310
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 #192954 is a reply to message #192902] Thu, 14 September 2006 06:36 Go to previous messageGo to next message
goudelly
Messages: 52
Registered: August 2006
Location: India
Member

Hi,

You have base tables in usr1 and access the same table to other schemas. You have to create the public synonyms to access the usr1 tables. If you are importing the data to usr2 it will over write the public synonyms. While importing you can give the igonre=y .



Thanks,

Mohan Reddy

Re: public synonyms [message #192984 is a reply to message #192954] Thu, 14 September 2006 08:45 Go to previous messageGo to next message
joy_division
Messages: 4640
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
maoro
Messages: 310
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 Go to previous message
maoro
Messages: 310
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
Previous Topic: information regarding Stats pack
Next Topic: How to rename a lob index created by Oracle ?
Goto Forum:
  


Current Time: Fri Dec 02 22:52:46 CST 2016

Total time taken to generate the page: 0.10874 seconds