NIM049811 for ArcSDE/Enterprise Geodatabase

Numéro d’ID de bogue	NIM049811
Envoi	October 14, 2009
Dernière modification	April 2, 2025
S’applique à	ArcSDE/Enterprise Geodatabase
Version trouvée	9.3.1
Statut	Will Not Be Addressed

Informations supplémentaires

No Public Explanation

Solution de contournement

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