topic Best way to maintain integer unique id column? in Data Management Questions https://community.esri.com/t5/data-management-questions/best-way-to-maintain-integer-unique-id-column/m-p/100410#M5866 <HTML><HEAD></HEAD><BODY><SPAN>I need to maintain a unique id column for feature classes in Oracle 11g.&nbsp; I can't use ObjectId, as my unique id can't change if I load the data into another database (soon to occur), since 3rd party software depends on the unique id being constant.&nbsp; It must be integer based (i.e., I can't use the UUID functionality available as 3rd party software won't read char column types).&nbsp; For that same reason, a class extension isn't preferred, as the complexities integrating with the 3rd party software raises concerns.&nbsp; I tried editing the INSTEAD OF INSERT trigger created by the multiversion view we have on the feature class, to get the nextval of a sequence and insert that instead of :new.ColumnValue, but even though the trigger compiles fine and inserts actually work properly, that sequence value is not inserted into the add table, nor the base table.&nbsp; So I'm wondering what the remaining options are, if there are any?&nbsp; Am I missing something terribly obvious?&nbsp; Why is it so hard to maintain a unique id column in ArcGIS?&nbsp; Thanks in advance.</SPAN></BODY></HTML> Tue, 18 Sep 2012 17:27:59 GMT ShawnHolyoak 2012-09-18T17:27:59Z Best way to maintain integer unique id column? https://community.esri.com/t5/data-management-questions/best-way-to-maintain-integer-unique-id-column/m-p/100410#M5866 <HTML><HEAD></HEAD><BODY><SPAN>I need to maintain a unique id column for feature classes in Oracle 11g.&nbsp; I can't use ObjectId, as my unique id can't change if I load the data into another database (soon to occur), since 3rd party software depends on the unique id being constant.&nbsp; It must be integer based (i.e., I can't use the UUID functionality available as 3rd party software won't read char column types).&nbsp; For that same reason, a class extension isn't preferred, as the complexities integrating with the 3rd party software raises concerns.&nbsp; I tried editing the INSTEAD OF INSERT trigger created by the multiversion view we have on the feature class, to get the nextval of a sequence and insert that instead of :new.ColumnValue, but even though the trigger compiles fine and inserts actually work properly, that sequence value is not inserted into the add table, nor the base table.&nbsp; So I'm wondering what the remaining options are, if there are any?&nbsp; Am I missing something terribly obvious?&nbsp; Why is it so hard to maintain a unique id column in ArcGIS?&nbsp; Thanks in advance.</SPAN></BODY></HTML> Tue, 18 Sep 2012 17:27:59 GMT https://community.esri.com/t5/data-management-questions/best-way-to-maintain-integer-unique-id-column/m-p/100410#M5866 ShawnHolyoak 2012-09-18T17:27:59Z