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

586
2
08-20-2014 03:38 AM
JoseSanchez
Occasional Contributor III

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

0 Kudos
2 Replies
Pieter_Geertvan_den_Beukel
Esri Contributor

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

0 Kudos
RichardMiedema1
Esri Contributor

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

0 Kudos