NIM049811 for ArcSDE/Enterprise Geodatabase

漏洞 ID 编号	NIM049811
已提交	October 14, 2009
上次修改时间	April 2, 2025
适用范围	ArcSDE/Enterprise Geodatabase
找到的版本	9.3.1
状态	Will Not Be Addressed

附加信息

No Public Explanation

解决办法

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