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 and later
Information in this document applies to any platform.


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


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