topic Oracle - view in schema A appears in schema B? in Geodatabase Questions https://community.esri.com/t5/geodatabase-questions/oracle-view-in-schema-a-appears-in-schema-b/m-p/797411#M2455 <HTML><HEAD></HEAD><BODY><P>Hi there,</P><P>we have an Oracle based Enterprise DB with multiple Oracle SDE schemas/users.</P><P>Now, when I create a view in Schema A I can see that view in Schema B in ArcCatalog (and all other ArcMap based tools). Which is not just annoying&nbsp;but also causes problems with one tool (running in Shema B) as it tries to process that view.</P><P>In Oracle SQL Developer I cannot see that view when I log in with Schema B. I can query the view when the schema qualifier is used, such as: select * from schemaa.view1.</P><P></P><P>Any idea what is going on here?</P><P>ArcMap 10.5.1, Oracle 11.2</P><P></P><P>Many thanks, Rob</P></BODY></HTML> Tue, 26 May 2020 08:36:35 GMT robert_at_work 2020-05-26T08:36:35Z Oracle - view in schema A appears in schema B? https://community.esri.com/t5/geodatabase-questions/oracle-view-in-schema-a-appears-in-schema-b/m-p/797411#M2455 <HTML><HEAD></HEAD><BODY><P>Hi there,</P><P>we have an Oracle based Enterprise DB with multiple Oracle SDE schemas/users.</P><P>Now, when I create a view in Schema A I can see that view in Schema B in ArcCatalog (and all other ArcMap based tools). Which is not just annoying&nbsp;but also causes problems with one tool (running in Shema B) as it tries to process that view.</P><P>In Oracle SQL Developer I cannot see that view when I log in with Schema B. I can query the view when the schema qualifier is used, such as: select * from schemaa.view1.</P><P></P><P>Any idea what is going on here?</P><P>ArcMap 10.5.1, Oracle 11.2</P><P></P><P>Many thanks, Rob</P></BODY></HTML> Tue, 26 May 2020 08:36:35 GMT https://community.esri.com/t5/geodatabase-questions/oracle-view-in-schema-a-appears-in-schema-b/m-p/797411#M2455 robert_at_work 2020-05-26T08:36:35Z