0

I have the following schema defined as mentioned here While executing the query

SELECT stn.id FROM station stn JOIN station_location_mpng stnloc ON stn.oid = stnloc.station_oid WHERE stnloc.location_oid = ?;

Am getting the following exception

ORA-01775: looping chain of synonyms
01775. 00000 -  "looping chain of synonyms"

This is occurring in one of my DB instance. Am a java developer not DBA could anyone point out why am getting exception as above.

MT0
  • 143,790
  • 11
  • 59
  • 117
mallikarjun
  • 1,862
  • 5
  • 23
  • 47
  • How the above will related to my question? – mallikarjun May 21 '19 at 08:12
  • It doesn't really matter if it's called from Java or not. It is a general Oracle error and something is wrong one the DB side. As the message suggests, the problem is most likely with looping synonyms for the tables on your DB. In that question I've linked people tell how to find out what is wrong. I'd problably start with the answer of Justin Cave (3rd one). – Amongalen May 21 '19 at 08:17
  • @Amongalen I found the problem. My DB instance has N schema so I just need to mention the SCHEMA name in front of table, to work properly. – mallikarjun May 21 '19 at 08:28
  • You probably should post your solution as an answer to this question and accept it just so it is more visible. – Amongalen May 21 '19 at 08:29
  • "How the above [duplicate] will relate to my question?" As stated in the top answer of the duplicate, this is commonly caused by a synonym pointing to an object that does not exist (or your current user does not have permissions to access). In your case you found a solution by adding a schema to the object identifier so that it could be correctly referenced. – MT0 May 21 '19 at 10:51

0 Answers0