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.

Dernière publication: August 25, 2014

No Product Found

Solution de contournement

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

ID de bogue: NIM006509

Logiciel:

Obtenir de l’aide auprès des experts ArcGIS

Contacter le support technique

Télécharger l’application Esri Support

Accéder aux options de téléchargement