Required few clarifications on accessing tables and synonyms between schemas and Databases.
Database: A ( Db Link: ABC)
- Schema: A1 -> Tables: Employee , Synonym: Employee_syn ( Private) , Employee ( Public) - Created as Public with same name as table)
- Schema: A2 -> Tables: Employee.
- Schema.A3 ->
Now i tried to access these objects from Database B. My queries are:
1. Select A1.employee@ABC -> Employee table will be accessed from Schema 1.
2. Select employee@ABC -> Which schema it will choose ? Schema A1 or A2? Table or Synonym(PUBLIC)?
3. Select A3.employee@ABC -> I believe, Public Synonym:Employee will be accessed in Schema 3. Please clarify.
Please explain, purpose of creating synonym with same table name in Public mode? How it can be accessed between databases and Schemas?
Thanks in advance.