So at my office I curate a lot of datasets maintained by other (ArcGIS-compatible, but not ArcGIS-using) departments, fed into an Oracle-based SDE, for consumption by all departments in an intranet web mapping system used by all departments and all divisions at my company.
One of the groups of data I have contains two feature classes of point data that are functionally very similar, and for an unrelated project it looked like I needed both FCs merged into one FC, so I tried to accomplish this using a union in a Spatial View:
(Table names have been changed and some fields removed for anonymity's sake)
CREATE OR REPLACE FORCE VIEW POINTS_COMBINED
SELECT CAST (ROWNUM AS INTEGER) AS OBJECTID, SHAPE
SELECT SHAPE FROM POINTS_1
SELECT SHAPE FROM POINTS_2
ORDER BY OBJECTID;
This seems to work perfectly - the total number of features in the Spatial View is the same as the sum of the features in the individual FCs.
With this, I decided to try the same method with a couple of polygon FCs, but for whatever reason I get the error "Stream Not Found" when I use literally the same SQL statement with the FC names changed to reflect the polygon FCs.
Any idea what I'm missing? I've checked the Spatial Reference for both and they're the same, so it's not that, as far as I can tell. Is it possibly just that polygon shape data is more complex than point shape data?