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.

Última Publicação: August 25, 2014

No Product Found

Solução Provisória

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

ID do Erro: NIM006509

Software:

Obtenha ajuda de especialistas do ArcGIS

Entre em contato com Suporte Técnico

Baixe o Aplicativo de Suporte da Esri

Ir para as opções de download