Home » SQL & PL/SQL » SQL & PL/SQL » synonym priority (oracle
synonym priority [message #327491] Mon, 16 June 2008 10:17 Go to next message
Messages: 32
Registered: June 2007
Hi, I got an issue with synonym priority. I got a public synonym pointing to a view in another schema, and I created a table with the same name with different data. Because of the restrictions I can't change the synonym name. Now when I select data I am getting data from synonym rather than table in the local schema.

Oracle documentation states that local objects take priority.

Pl advise
Re: synonym priority [message #327495 is a reply to message #327491] Mon, 16 June 2008 10:33 Go to previous message
Michel Cadot
Messages: 63920
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Priority is:
- local object
- private synonym
- public synonym

If you have something that does not fit this, please post a test case we can reproduce.

Previous Topic: Multi Table Update / Join syntax not working
Next Topic: SQL Query Help - Creating Report
Goto Forum:

Current Time: Tue Oct 25 07:46:57 CDT 2016

Total time taken to generate the page: 0.14881 seconds