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: 65155
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: Tablespace issues
Next Topic: Cursor_sharing
Goto Forum:

Current Time: Thu Aug 24 05:46:37 CDT 2017

Total time taken to generate the page: 0.05714 seconds