Bug: Oracle 11.2.0.2 Constraint on SDO

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.

Article ID:000011194

Software: