modify/alter column length on sde9.3.1 for oracle

irishadar — Sun, 02 Sep 2012 08:35:47 GMT

Hi,
I've created a feature class with arc catalog 10 in arcsde on oracle ST_GEOMETRY type.
I needed to change one of the columns from long integer 8 to long integer 10.

If I'm using pure oracle sql it's only changing the length in oracle, arc catalog still see the original length (8).

For some reason when we changed the text column the same way, arc catalog did see the changes.

I've even looked in "ARCSDE Administration Command" both in "sdelayer" and "sdetable" but couldn�??t find any command but the one for changing data type.

What is the best way for changing column length on ST_GEOMETRY type?

Tank's ahead
Iris Hadar

Re: modify/alter column length on sde9.3.1 for oracle

VinceAngelo — Sun, 02 Sep 2012 11:11:53 GMT

You're not changing the length of an ST_GEOMETRY, you're changing the display size of
numeric column in a table (which happens to contain a geometry column).

The supported mechanism to doing database design changes is to backup the table, drop
the table, recreate the table (with the new layout), and repopulate the table (from backup,
if possible). I use this nearly exclusively.

It may also be possible to use SQL to alter the table (if it's not versioned), then use 'sdetable
-o describe' (as the owner) to convince ArcSDE to re-evaluate the table contents.

Finally, the unsupported mechanisms involve hacking the column registry table and/or the
geodatabase XML. I *never* mess with the XML, since a simple mistake can trash the entire
instance (though the same is true for etiher mechanism, which is why they're unsupported).

- V

topic Re: modify/alter column length on sde9.3.1 for oracle in Data Management Questions

modify/alter column length on sde9.3.1 for oracle

Re: modify/alter column length on sde9.3.1 for oracle