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.

Zuletzt veröffentlicht: August 25, 2014

No Product Found

Workaround

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

Bug-ID: NIM006509

Software:

Unterstützung durch ArcGIS-Experten anfordern

An den technischen Support wenden

Esri Support App herunterladen

Zu Download-Optionen wechseln