AnsweredAssumed Answered

OBJECTID values in Oracle

Question asked by RudinA on Feb 24, 2016
Latest reply on Feb 25, 2016 by vangelo-esristaff

Where do OBJECTID values on a feature class in Oracle come from when inserts occur?  Is it a sequence somewhere, or does ArcMap scan to find the current maximum ID and do a +1 operation before the insert?  In my situation the feature class is versioned and uses ST Geometry.

 

The feature class also has archiving enabled, so does the GDB_ARCHIVE_OID value on the archive table use the same mechanism to create OBJECTID values when records are inserted there when edits are posted to default?

Outcomes