Easiest way to change field lenght for editor tracking fields

HeathAnderson · ‎05-01-2024

In an Enterprise database what is the easiest way to change the field length for the editor tracking fields. It was initially set at 25 which is way to short to store SSO username. I want to change it to 255 but am unsure of the best, most efficent way of going about this.

Cheers,

Heath

MarceloMarques · ‎05-01-2024

@HeathAnderson - in ArcGIS Pro, disable editor tracking, add a new filed with the new size, update the new field with the values of the old field, delete the old field, re-enable editor tracking.

| Marcelo Marques | Esri Principal Product Engineer | Cloud & Database Administrator | OCP - Oracle Certified Professional | "In 1992, I embarked on my journey with Esri Technology, and since 1997, I have been working with ArcSDE Geodatabases, right from its initial release. Over the past 32 years, my passion for GIS has only grown stronger." | “ I do not fear computers. I fear the lack of them." Isaac Isimov |

View solution in original post

MarceloMarques · ‎05-01-2024

@HeathAnderson - in ArcGIS Pro, disable editor tracking, add a new filed with the new size, update the new field with the values of the old field, delete the old field, re-enable editor tracking.

| Marcelo Marques | Esri Principal Product Engineer | Cloud & Database Administrator | OCP - Oracle Certified Professional | "In 1992, I embarked on my journey with Esri Technology, and since 1997, I have been working with ArcSDE Geodatabases, right from its initial release. Over the past 32 years, my passion for GIS has only grown stronger." | “ I do not fear computers. I fear the lack of them." Isaac Isimov |