Bug
A numeric primary key is automatically adopted as the ObjectID when registering a spatial table in Oracle with a geodatabase.
| Bug ID Number | BUG-000099797 |
|---|---|
| Submitted | October 4, 2016 |
| Last Modified | June 5, 2024 |
| Applies to | ArcSDE/Enterprise Geodatabase |
| Version found | 10.2.2 |
| Status | Duplicate |
Additional Information
Duplicate of BUG-000088358: Addressed in 10.5 by BUG-000088358Workaround
Workaround 1: Create the table with a unique constraint rather than a primary key constraint and register it with the geodatabase. This results in a dialog box prompting the user if they would like to use the unique numeric field or create a new OID field.Workaround 2: Use the ArcSDE command line tools 'sdelayer -o register' with the '-C' option to specify if the row ID is to be registered as user maintained or ArcSDE maintained.Steps to Reproduce
Bug ID: BUG-000099797
Software:
- ArcSDE/Enterprise Geodatabase
Get notified when the status of a bug changes
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App