Select to view content in your preferred language

Easiest way to change field lenght for editor tracking fields

190
1
Jump to solution
05-01-2024 12:24 PM
HeathAnderson
Occasional Contributor II

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

0 Kudos
1 Solution

Accepted Solutions
MarceloMarques
Esri Regular Contributor

@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 | Principal Product Engineer | Esri |
| Cloud & Database Administrator | OCP - Oracle Certified Professional |
I work with Enterprise Geodatabases since 1997.
“ I do not fear computers. I fear the lack of them." Isaac Isimov

View solution in original post

0 Kudos
1 Reply
MarceloMarques
Esri Regular Contributor

@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 | Principal Product Engineer | Esri |
| Cloud & Database Administrator | OCP - Oracle Certified Professional |
I work with Enterprise Geodatabases since 1997.
“ I do not fear computers. I fear the lack of them." Isaac Isimov
0 Kudos