NIM049811 for ArcSDE/Enterprise Geodatabase

Bug ID Number	NIM049811
Submitted	October 14, 2009
Last Modified	April 2, 2025
Applies to	ArcSDE/Enterprise Geodatabase
Version found	9.3.1
Status	Will Not Be Addressed

Additional Information

No Public Explanation

Workaround

Manually update the sde.column_registry table:TEST1@ORCL>select column_name, sde_type, column_size, decimal_digits from sde.column_registry where table_name = 'TESTDT1' and column_name = 'PS';COLUMN_NAME SDE_TYPE COLUMN_SIZE DECIMAL_DIGITS-------------------------------- ---------- ----------- --------------PS 4 38 10TEST1@ORCL>conn sde/sdeConnected.SDE@ORCL>update sde.column_registry set sde_type = 2 where table_name = 'TESTDT1' and column_name = 'PS';1 row updated.SDE@ORCL>update sde.column_registry set column_size = 10 where table_name = 'TESTDT1' and column_name = 'PS';1 row updated.SDE@ORCL>update sde.column_registry set decimal_digits = null where table_name = 'TESTDT1' and column_name = 'PS';1 row updated.SDE@ORCL>select column_name, sde_type, column_size, decimal_digits from sde.column_registry where table_name = 'TESTDT1' and column_name = 'PS';COLUMN_NAME SDE_TYPE COLUMN_SIZE DECIMAL_DIGITS-------------------------------- ---------- ----------- --------------PS 2 10SDE@ORCL>commit;Commit complete.Preview in ArcCatalog, it is shown as LONG INTEGER