Conflict between local tables and public synonyms in oracle

fcaponi · **Posted:** Mon Mar 19, 2007 11:57 am

Hi all,
I'm experiencing problems with schema valdation because a local table has the same name of a public synonyms, and some columns are validated against the public synonym.

I know that exists an attribute "schema" but i cannot fix the name in the mapping because it can change between development, production, test and so on.

Exists a way to define a priority?

Any help is appreciated

Regards
Franco

tenwit · **Joined:** Thu Dec 23, 2004 9:08 pm **Posts:** 2008

Depends on the database. In SQLServer, you can quote the string either in backquotes, or better, in square brackets. So

Code:

select * from select

is nonsense, but

Code:

select * from [select]

will return all values from the table called "select".