AnsweredAssumed Answered

Arcgis 10.2 objectid returning non sequential values

Question asked by davidzornosa on Oct 11, 2017
Latest reply on Oct 12, 2017 by asrujit_pb

Hello

 

i am making a sql insert in a geotable. I'm getting the objectid via:

 

    sde.gdb_util.next_rowid('my_user', 'my_table')

 

However, i've noticed that numbers given are not always in sequence. For instance, if i run the script 6 times, i get:

 

    run|oid
    ---|------
      1| 1601
      2| 1602
      3| 1603
      4| 1917
      5| 1918
      6| 1604
      
Is this normal? I know that for ids the only important thing is uniqueness, and sequentiality is optional, but i'm intrigued.

 

Thanks

Outcomes