Bug: Oracle 220.127.116.11 constraint on SDO_DIMNAME
Oracle 18.104.22.168 is incompatible with ArcGIS Server 10.0 SP2 and earlier versions when using versioned Oracle Spatial feature classes.
An Oracle error is returned when:
• A multi-versioned view of a previously versioned table containing a SDO_GEOMETRY column is created.
The Oracle error message:
ERROR at line 1:
ORA-13249: Only alphanumeric characters and "_" are allowed in SDO_DIMNAME
ORA-06512: at "MDSYS.MD", line 1723
ORA-06512: at "MDSYS.MDERR", line 17
ORA-06512: at "MDSYS.CHK_SDO_DIMNAME", line 11
ORA-04088: error during execution of trigger 'MDSYS.CHK_SDO_DIMNAME'
ORA-06512: at "MDSYS.SDO_GEOM_TRIG_INS1", line 43
ORA-04088: error during execution of trigger 'MDSYS.SDO_GEOM_TRIG_INS1'
Oracle added a restriction on valid SDO_DIMNAME entries in Oracle 22.214.171.124; see Oracle bug number 11666567. This restriction does not allow spaces in the SDO_DIMNAME field of the SDO_DIMINFO type, which itself is part of the SDO_GEOMETRY type. ArcGIS Server currently inserts the following SDO_DIMNAME values for delta tables and multiversioned views.
• For the MV View: "_ArcSDE IMV Table_"
Do not use the SDO_GEOMETRY storage type for versioned feature classes when using Oracle 126.96.36.199 or later with ArcGIS Server 10.0 SP2 or earlier.
This issue has been addressed at ArcGIS Server 10 SP3. Esri has also released a software patch for this issue for ArcGIS Server 9.3.1 SP2. This patch is available for download: ArcSDE 9.3.1 Service Pack 2 Register as Versioned using Oracle Spatial Data Patch.