| Register | FAQ | Calendar | Search | Today's Posts | Mark Forums Read |
|
#1
|
| Hi I am new to oracle. Can any one help me how to access public synonym using schema name? (Eg) Table name : Employee Owner : swift select * from swift.Employee --> Its working Like above i need for public synonym : SynEmployee select * from SynEmployee --> Its working select * from swift.Employee --> Giving error Instead of swift what i have to use for public synonym? In simple words, In sql we will use dbo.object name in query.Like that i am searching for oracle public synonym Thanks in Advance Regards, Arun |
|
#2
|
| while you try to access the synonym,what is the error you are getting ? |
|
#3
|
| What you are saying is in conflict with the way public synonyms are used. You create a public synonym so you don’t have to put the owner. In the query. Please let me know if you need more help. |
![]() |
| Thread Tools | |
| Display Modes | |