Expdp W/transport_tablespaces Set To A Tablespace With A Spatial Index = ORA-39127 ORA-6531 (Doc ID 1479989.1)

Last updated on JANUARY 26, 2014

Applies to:

Oracle Spatial and Graph - Version 11.2.0.2 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.
***Checked for relevance on 27-Jan-2014***

Symptoms

Using Data Pump export (expdp) with transport_tablespaces set to a tablespace that has a Spatial index fails.

For example, this command:

    expdp "'/ as sysdba'" parfile=exptts.dat

with these parfile contents:

    directory=spatial_dir
    dumpfile=exp.dmp
    logfile=exp.log
    transport_tablespaces= SPATIAL_TEST

fails with:

     "...
     Processing object type TRANSPORTABLE_EXPORT/DOMAIN_INDEX/SECONDARY_TABLE/INDEX
     Completed 41 INDEX objects in 3 seconds
     Processing object type TRANSPORTABLE_EXPORT/DOMAIN_INDEX/INDEX
     ORA-39127: unexpected error from call to local_str := SYS.DBMS_EXPORT_EXTENSION.GET_DOMAIN_INDEX_METADATA('MST_MD_ADM_BNDS_N1','MST','SDO_INDEX_METHOD_10I','MDSYS',11.02.00.02.00,newblock,128)
     ORA-06531: Reference to uninitialized collection
     ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 270
     ORA-06512: at line 1
     ORA-06512: at "SYS.DBMS_METADATA", line 6830
     ORA-39127: unexpected error from call to local_str := SYS.DBMS_EXPORT_EXTENSION.GET_DOMAIN_INDEX_METADATA('RRS_SITE_TMP_N1','RRS','SDO_INDEX_METHOD_10I','MDSYS',11.02.00.02.00,newblock,128)
     ORA-06531: Reference to uninitialized collection
     ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 270
     ORA-06512: at line 1
     ORA-06512: at "SYS.DBMS_METADATA", line 6830
     ORA-39127: unexpected error from call to local_str := SYS.DBMS_EXPORT_EXTENSION.GET_DOMAIN_INDEX_METADATA('HR_LOCATIONS_SPT','HR','SDO_INDEX_METHOD_10I','MDSYS',11.02.00.02.00,newblock,128)
     ORA-06531: Reference to uninitialized collection
     ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 270
     ORA-06512: at line 1
     ORA-06512: at "SYS.DBMS_METADATA", line 6830
     Completed 44 INDEX objects in 12 seconds
     Processing object type TRANSPORTABLE_EXPORT/RLS_POLICY/RLS_POLICY
     Completed 480 RLS_POLICY objects in 1 seconds
     ..."

Note:  This problem only occurs against tables with SDO_GEOMETRY columns where either:
    a.  the table (and therefore the geometry column) is empty
or
    b.  the table has rows but the geometry column values are all NULL.

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