Arcgis 10.2 objectid returning non sequential values

davidzornosa — Wed, 11 Oct 2017 21:12:39 GMT

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

topic Arcgis 10.2 objectid returning non sequential values in Data Management Questions

Arcgis 10.2 objectid returning non sequential values

Re: Arcgis 10.2 objectid returning non sequential values