topic Re: Issue with Oracle Synonym in QlikView https://community.qlik.com/t5/QlikView/Issue-with-Oracle-Synonym/m-p/935998#M1255754 <HTML><HEAD></HEAD><BODY><P>To avoid this problem, have 3 tier architecture.. store all relevant source tables into QVDs and then use transformations, this will not have that oracle "synonym" issue.</P><P></P><P>HTH</P><P>Sreeni</P></BODY></HTML> Mon, 28 Sep 2015 09:48:48 GMT SreeniJD 2015-09-28T09:48:48Z Issue with Oracle Synonym https://community.qlik.com/t5/QlikView/Issue-with-Oracle-Synonym/m-p/935996#M1255750 <HTML><HEAD></HEAD><BODY><P>Has anyone come across error with synonym on oracle tables? seems to time out as it thinks the table is either not there but when I run the same script in oracle or toad using the same user id and password credentials, it runs with no problem. Can anyone help with this?</P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT https://community.qlik.com/t5/QlikView/Issue-with-Oracle-Synonym/m-p/935996#M1255750 l_palacios 2026-01-26T18:19:17Z Re: Issue with Oracle Synonym https://community.qlik.com/t5/QlikView/Issue-with-Oracle-Synonym/m-p/935997#M1255752 <HTML><HEAD></HEAD><BODY><P>Does a simple <EM>select * from tablename</EM> <SPAN style="font-size: 13.3333px;">from QV </SPAN>against a simple small Oracle table work ok ?</P></BODY></HTML> Mon, 28 Sep 2015 09:41:49 GMT https://community.qlik.com/t5/QlikView/Issue-with-Oracle-Synonym/m-p/935997#M1255752 Anonymous 2015-09-28T09:41:49Z Re: Issue with Oracle Synonym https://community.qlik.com/t5/QlikView/Issue-with-Oracle-Synonym/m-p/935998#M1255754 <HTML><HEAD></HEAD><BODY><P>To avoid this problem, have 3 tier architecture.. store all relevant source tables into QVDs and then use transformations, this will not have that oracle "synonym" issue.</P><P></P><P>HTH</P><P>Sreeni</P></BODY></HTML> Mon, 28 Sep 2015 09:48:48 GMT https://community.qlik.com/t5/QlikView/Issue-with-Oracle-Synonym/m-p/935998#M1255754 SreeniJD 2015-09-28T09:48:48Z Re: Issue with Oracle Synonym https://community.qlik.com/t5/QlikView/Issue-with-Oracle-Synonym/m-p/935999#M1255755 <HTML><HEAD></HEAD><BODY><P>Hi Sreeni,</P><P>thank you for your help. I tried restructuring the architecture of the table and that seems to have helped. I also, streamlined the amount of data I am pulling in. that is working also. thank you for your help.</P></BODY></HTML> Thu, 08 Oct 2015 16:48:46 GMT https://community.qlik.com/t5/QlikView/Issue-with-Oracle-Synonym/m-p/935999#M1255755 l_palacios 2015-10-08T16:48:46Z Re: Issue with Oracle Synonym https://community.qlik.com/t5/QlikView/Issue-with-Oracle-Synonym/m-p/936000#M1255756 <HTML><HEAD></HEAD><BODY><P>Glad that it has worked! Please close the thread by marking correct or helpful <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 09 Oct 2015 03:51:10 GMT https://community.qlik.com/t5/QlikView/Issue-with-Oracle-Synonym/m-p/936000#M1255756 SreeniJD 2015-10-09T03:51:10Z