I'm looking for the simplest way to track changes ([delete, update, create] feature(s)) made to the DEFAULT version of a given feature class in ArcSDE(10) and Oracle(11g).
Qualifier: I am not a dba and I have only enough of an understanding of versions to get by as a self-proclaimed developer.
I'm trying to avoid:
- Mucking around with state IDs, delta tables, and triggers if poss.
- Running expensive feature-by-feature comparisons with target datasets.
I'm hoping to access this 'change log' table/query with python/cxOracle or .Net if necessary.
Update: *Here are some additional items I'd like to avoid:*
- Developing, deploying, and managing custom editing class extensions to all editing users' machines.
- Upgrading to ArcGIS 10.1