How to increase the size of a filed in an SDE Oracle database

Question

Hi all,

I am using an SDE Oracle 11G database with ArcGIS 10.x and I need to icnrease th size of a text field in a feature class from 5 to 7 characters. The layer is not versioned.

What is the best way to do it?

I already tried to open the table associated with the feature calls using Oracle SQL Developer and to modify the size of the field in the table, but after doing this modification all the users get an error message saying that the schema is outdated. Is there a way to do that with ArcCatalog?

Thanks

Anonymous User · Answer

Field changes can be done easily within ArcCatalog or ArcMap.  Doing so assures you your data changes will be interpreted correctly within the Enterprise geodatabase.

http://resources.arcgis.com/en/help/main/10.2/index.html#//003n00000100000000

Pieter_Geertvan_den_Beukel · Answer

the message 'schema out of date' can be resolved by using the old command line SDE tools: sdetable -o describe_long