English

Bug: 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:

• A table that contains an SDO_GEOMETERY spatial type column is registered as a versioned table.

Or

• 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'



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.

• For the Adds table: "_ArcSDE Delta Table_"
• For the MV View: "_ArcSDE IMV Table_"

Workaround

Do not use the SDO_GEOMETRY storage type for versioned feature classes when using Oracle 11.2.0.2 or later with ArcGIS Server 10.0 SP2 or earlier.

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.

    Related Information