Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

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.

Anybody have any experience to share?

share|improve this question

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?

share|improve this answer
    
unversioned, so no A and D table complications. –  MC5 Apr 11 '13 at 21:38

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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