Can you edit an ArcSDE Oracle spatial view?

By 'edit' I mean edit the geometry in the feature class, not any attributes in the joined table. Unversioned.

I really had it in my head that you can, as long as the objectid column is included in the view along with the shape column, some half-remembered reference. So I was forging ahead and decided to double-check if there was fine print, and now it seems I was whackadoodle in the first place.

I've seen nothing to suggest it is supported, and seen in Administering ArcSDE for Oracle, page 225: "Spatial views cannot be edited through an ArcSDE client."

But then I went ahead and tried it today, and I could edit a spatial view in ArcMap, but given the above I question how safe it is.

1 Answer 1


Native RDBMS views should probably not be edited. I have never edited one in ArcMap, just with SQL so I haven't edited geometry. I've done attribute updates in the past but it is dangerous because the view is unaware of the A & D tables, assuming your data is versioned. insert and delete operations can really get you into trouble.

If the data is versioned can you use a (multi)versioned view instead?

  • unversioned, so no A and D table complications.
    – MC5
    Apr 11, 2013 at 21:38

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.