Oracle 11.2.0.2 constraint on SDO_DIMNAME

Description

Oracle 11.2.0.2 is incompatible with ArcGIS Server 10.0 SP2 and earlier versions when using versioned Oracle Spatial feature classes. An Oracle error is returned when:

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'

Cause

Oracle added a restriction on valid SDO_DIMNAME entries in Oracle 11.2.0.2; 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.

Workaround

Note:
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.