AnsweredAssumed Answered

Oracle - view in schema A appears in schema B?

Question asked by _robert_ on May 26, 2020

Hi there,

we have an Oracle based Enterprise DB with multiple Oracle SDE schemas/users.

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 but also causes problems with one tool (running in Shema B) as it tries to process that view.

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.

 

Any idea what is going on here?

ArcMap 10.5.1, Oracle 11.2

 

Many thanks, Rob

Outcomes