I'm considering switching some of my tables in an Oracle enterprise geodatabase from versioned
to unversioned
.
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
default
version (without creating separate versions). -
It's only possible to edit either
registered
orunregistered
tables 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
unregistered
tables.
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?
Best Answer
The best resource I've come across to provide an answer is Esri's Not registered as versioned or unregistering data as versioned
There are no ways I'm aware of redoing/undoing edits in unregistered tables. However, this resource provides further insight as to possibly finding a solution.