topic Re: Object Id Reset in Geoprocessing Questions

Object Id Reset

AnnCrystal — Fri, 09 Mar 2012 19:59:17 GMT

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

Re: Object Id Reset

DuncanHornby — Tue, 13 Mar 2012 16:37:46 GMT

Ann,

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

Duncan

Re: Object Id Reset

AnnCrystal — Tue, 13 Mar 2012 17:04:10 GMT

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

Re: Object Id Reset

DuncanHornby — Tue, 13 Mar 2012 19:21:00 GMT

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