Data Pump Import encounters ORA-31693,ORA-02354,ORA-39779 errors on MDSYS.MBRCOORDLIST objects.

(Doc ID 2349444.1)

Last updated on JANUARY 31, 2018

Applies to:

Oracle Spatial and Graph - Version 11.2.0.0 and later
Information in this document applies to any platform.

Symptoms

Following errors occurs when export GeoCode data from 11g database into 12c database


ORA-31693: Table data object "SDEDATA"."MDXT_1C20A$_BKTS" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-39779: type "MDSYS"."MBRCOORDLIST" not found or conversion to latest version is not possible

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