Bug
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.
| Bug ID Number | NIM006509 |
|---|---|
| Submitted | February 1, 2007 |
| Last Modified | April 2, 2025 |
| Applies to | No Product Found |
| Version found | 9.2 |
| Version Fixed | 9.3 |
| Status | Fixed |
Workaround
Register the table with a row id column using sdetable -o alter_reg before adding the ST_GEOMETRY or SDO_GEOMETRY spatial column.Steps to Reproduce
Bug ID: NIM006509
Software:
- No Product Found
Get notified when the status of a bug changes
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App