Hi All,
We have oracle 11.2.0.4 on Redhat.
We have three schema like User1,user2 and Dummy1 ;
User1 and user2 have tables. Some of the tables are same structure ( including table name & column name ) in both schema User1 and user2.
Synonyms are created on Dummy1 for the schema User1 and user2.
For Ex : The table EMP has 2 columns Col1 & col2 in both schema.
I can select both tables with schemaname.tablename.
when i execute select statement without schema name,
how it works?which schema data's retrieved whether User1 or user2?
Thanks