ORA-39127, ORA-13249 from EXP and EXPDP when exporting Spatial indexes in 11.2 (Doc ID 1285364.1)

Last updated on DECEMBER 10, 2015

Applies to:

Oracle Spatial and Graph - Version 11.2.0.2 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.
***Checked for relevance on 21-Jun-2015***


Symptoms

Since upgrading the database to 11.2.0.2, EXP and EXPDP generate errors while exporting some Spatial indexes:

EXP:

EXP-00008: ORACLE error 13249 encountered
ORA-13249: Only alphanumeric characters and "_" are allowed in SDO_DIMNAME
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 270
ORA-06512: at line 1
EXP-00078: Error exporting metadata for index SDO_INDEX_A. Index creation will be skipped


EXPDP:

...
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/INDEX/DOMAIN_INDEX/INDEX
ORA-39127: unexpected error from call to local_str := SYS.DBMS_EXPORT_EXTENSION.GET_DOMAIN_INDEX_METADATA('SDO_INDEX_A','USER_A','SDO_INDEX_METHOD_10I','MDSYS',11.02.00.01.00,newblock,0)
ORA-13249: Only alphanumeric characters and "_" are allowed in SDO_DIMNAME
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 270
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_METADATA", line 6498
ORA-39127: unexpected error from call to local_str := SYS.DBMS_EXPORT_EXTENSION.GET_DOMAIN_INDEX_METADATA('SDO_INDEX_B','USER_A','SDO_INDEX_METHOD_10I','MDSYS',11.02.00.01.00,newblock,0)
ORA-13249: Only alphanumeric characters and "_" are allowed in SDO_DIMNAME
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 270
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_METADATA", line 6498
...

Changes

Beginning 11.2.0.2, the DIMINFO of Spatial indexes in MDSYS.SDO_GEOM_METADATA_TABLE cannot have a <space> in SDO_DIMNAME.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms