laptop and a wrench

漏洞

When you attempt to add an ST_GEOMETRY or SDO_GEOMETRY column to a populated table, the following error occurs: 'ORA-01758: table must be empty to add mandatory (NOT NULL) column.' Examples include loading a raster with the sderaster command as SDO_GEOMETRY or ST_GEOMETRY and attempting to register it with the geodatabase. This causes the data to become unusable. Also, raster catalogs created outside of ArcObjects cannot be registered with the geodatabase.

上次发布: August 25, 2014 No Product Found
漏洞 ID 编号 NIM006509
已提交February 1, 2007
上次修改时间April 2, 2025
适用范围No Product Found
找到的版本9.2
修正版本9.3
状态Fixed

解决办法

Register the table with a row id column using sdetable -o alter_reg before adding the ST_GEOMETRY or SDO_GEOMETRY spatial column.

重现步骤

漏洞 ID: NIM006509

软件:

  • No Product Found

当漏洞状态发生变化时获得通知

下载 Esri 支持应用程序

发现关于本主题的更多内容

获取来自 ArcGIS 专家的帮助

联系技术支持部门

下载 Esri 支持应用程序

转至下载选项