I have a materialized view that runs nightly and performs an intersection of point locations and polygons. The materialized view works as designed and returns the desired results. It contains attributes from the point and polygon used in the intersect operation, including a unique objectid field and geometry field.
Now, I need to create a spatial view. First, can I create a spatial view that gets its data from a materialized view? If so, how?
I used the SDE command line to create a view and modified the query to include some additional fields. After my edits, the spatial view seems to work fine in TOAD. Performing a SELECT against the spatial view returns the data expected.
When I try to add the SV to ArcMap, I get the following message:
could not add the specified data object to the map. Attribute column not found [schema.spatial_view][STATE_ID = 718731] Attribute column not found [schema.spatial_view][STATE_ID = 718731] Attribute column not found [schema.spatial_view][STATE_ID = 718731]
I tried dragging & dropping the spatial view from the Catalog onto the map surface as well as the Add Data button. Both produced the same message. This is causing me question my process and wondering if a) there's something on the backend that isn't wired up correctly or b) this is just not possible.
In ArcCatalog and the Catalog window in ArcMap, the icon adjacent to the spatial view is the icon used for data tables. It's not the point, line or polygon icons I see adjacent to the spatial views that work correctly. So arc thinks this spatial view is a data table and doesn't contain the polygon data it actually contains?