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, 2014No 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.