Select to view content in your preferred language

Oracle - view in schema A appears in schema B?

05-26-2020 01:36 AM
New Contributor III

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

Tags (2)
0 Kudos
0 Replies