Arcgis 10.2 objectid returning non sequential values

737
1
10-11-2017 02:12 PM
davidzornosa
New Contributor III

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

0 Kudos
1 Reply