Hello all,
I'm running SDE 10 on Oracle 11.1.0.7.0; what I have are two tables - one with just objectid and ST_GEOMETRY fields, and the other with some attribute data. Now I can join these tables just fine (on objectid, which is a PK for both tables), register the layer via sdelayer, and they show up and work fine in arcmap.
But:
Arcmap shows that the view-based feature class has no spatial index, and sdelayer - o describe_long shows the layer as having SPIDX_NONE (-1,0,0). The spatial table that the view is built off of does have an index, which both Arc and sdelayer recognize.
I've seen a handful of posts on the forum describing similar situations, but as far as I can tell, none of them have been resolved; has anyone out there gotten this to work, or is it just unsupported?
Thanks in advance,
IMF