Object Id Reset

7541
3
03-09-2012 11:59 AM
AnnCrystal
New Contributor II
I am having a weird problem with Object ID while deleting and appending features to a SDE Gdb v.9.2. When I empty the Feature Class using Delete Features and reload the data using AppendFeatures, Object Id repopulates starting with the next record # of the deleted record? How can I reset the Object Id to start from 1?

Thanks in advance
Ann
0 Kudos
3 Replies
DuncanHornby
MVP Frequent Contributor
Ann,

Run the Compact GeoDatabase tool after you have deleted all your features.

Duncan
0 Kudos
AnnCrystal
New Contributor II
Thanks Duncan. I don't see a tool which compacts SDE GDB. Compact Geodatabase tool applies only for File or Personal GDB. Please correct me if I am wrong. Is there a similar tool for SDE GDB?
Thanks agan
Ann
0 Kudos
DuncanHornby
MVP Frequent Contributor
Ann,

Looks like you are right those tools won't work with ArcSDE. I've never used ArcSDE but I know the problem you described occurs in personal and file geodatabases and the compact tool resolves that.

According to this old thread it suggests the issue is with the underlying database. This page lists a whole bunch of commands one resetting minimum row ID, not sure how you would impliment those having never used ArcSDE?

Duncan
0 Kudos