I'm considering switching some of my tables in an Oracle enterprise geodatabase from
The pros of having
unversioned tables would be:
- Simpler, traditional database design
- Database-level foreign keys and primary keys
- Triggers, without having to deal with versioned views
- Unique indexes
- Not having to constantly compress tables
- Grant and revoke update, insert, and delete privileges individually
But of course, there are a few cons:
Users can't create and edit named versions. This isn't a huge problem for me, because my organization ultimately doesn't use versioning technology properly anyway. We don't really do long-transaction editing, which is what versioning is intended for. Instead, we just do short transactions on the
defaultversion (without creating separate versions).
It's only possible to edit either
unregisteredtables in an edit session. Not both. So users have to stop editing and switch between edit modes to edit one kind of data or the other.
It's not possible to undo or redo edits in an edit session on
This last one is a potential deal breaker. It's really quite infuriating to not be able to undo an edit in an edit session. Sure, the user can stop editing, and not save the changes, but then they lose all the unsaved edits in that edit session.
Is there a way to undo/redo edits on
unregistered tables in ArcGIS Desktop?