idea Reset ObjectID when truncating table in ArcGIS Pro Ideas

Reset ObjectID when truncating table

Bud — Thu, 22 Jun 2023 18:58:41 GMT

When using the Truncate Table geoprocessing tool:

It would be helpful if we had the option to reset the ObjectID sequence, so that new rows start at ObjectID 1, etc.

Use Case:
We have large tables that we clear and reload on a schedule. We don't want to deal with huge ObjectIDs over time. And we don't want to delete the table and recreate it. Resetting the ObjectID would solve this issue.

Oracle 18c 10.7.1 EGDB

Re: Reset ObjectID when truncating table

MichaelVolz — Thu, 22 Jun 2023 20:45:16 GMT

Bud:

When I use the Truncate Table tool it resets the OBJECTID back to 1 for me so when I append records they start at 1. I used to use the Delete Rows method which did not reset the OBJECTID and that caused problems over time.

Re: Reset ObjectID when truncating table

MarceloMarques — Sat, 24 Jun 2023 23:16:42 GMT

you can truncate the table with SQL as long as it is not registered as versioned ( traditional / branch ).

truncate table table_A;

https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/TRUNCATE-TABLE.html#GUID-B76E5846-75B5-4876-98EC-439E15E4D8A4

then after the table is truncated, you can use SQL to reset the sequence.

alter sequence serial restart start with 1;

SQL Language Reference (oracle.com)

Example:

Re: Reset ObjectID when truncating table - Status changed to: Closed

SSWoodward — Fri, 23 Jun 2023 17:32:54 GMT

Aftenoon @Bud,

Could you let me know what version of Pro you are using so I can try to reproduce in your same environment?

The Truncate GP tool does reset your Object IDs after running. This is how it is designed to work. If this is not the behavior you're seeing, it means that the specific workflow being executed is exposing a bug.

Since this is a bug and not and Idea, I'm going to close this thread. Please make sure to file a bug for this that contains your specific workflow so that we can figure out what's going on and get a fix.

Re: Reset ObjectID when truncating table

MarceloMarques — Mon, 26 Jun 2023 23:05:35 GMT

Indeed. I tested with Pro 3.1.2 just to make sure, and the "Truncate Table" GP tool does reset the "Sequence" back to "1". See screenshots below.