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 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
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?