Copy/paste FC in Catalog — Maintain row order

Bud — Tue, 28 Nov 2023 22:51:06 GMT

ArcGIS Pro 2.6.8; Oracle 18c 10.7.1 EGDB:

I have a FC where the last OBJECTID in the attribute table is 205132 (without sorting). That OBJECTID is also the largest.

If I copy/paste the FC using Catalog, the largest OBJECTID is still 205132. See Export FC while maintaining ObjectID values. However, 205132 is no longer the last row in the attribute table:

In other words, the rows have been rearranged in the pasted FC.

I'm wondering, should the copy/paste tool in Catalog be changed so that it doesn't rearrange the rows? I'm aware that row order in a database table is arbitrary and can change over time. But when doing data management tasks in Catalog, such as copying/pasting a FC, I would have expected the row order to be maintained, at least when the initial paste was performed.

If the row order can't be maintained due to quirks in the underlying database, then maybe it would make sense to sort the rows by OBJECTID in the pasted FC instead. That would be more intuitive than rearranging the rows arbitrarily.

idea Copy/paste FC in Catalog — Maintain row order in ArcGIS Pro Ideas

Copy/paste FC in Catalog — Maintain row order