My Oracle Support Banner

ORA-31693, ORA-02354, ORA-39779: type "MDSYS"."MBRCOORDLIST" not found or conversion to latest version is not possible (Doc ID 2994911.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Spatial and Graph - Version 12.1.0.2 to 12.2.0.1 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

While importing a *.dmp file from a 12.1.0.2 or older SOURCE database via IMPDP, the import of <owner>.MDXT_*$_BKTS and <owner>.MDXT_*$_MBR tables fail with errors:

ORA-31693: Table data object "SOMEUSER"."MDXT_42534$_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
ORA-31693: Table data object "SOMEUSER"."MDXT_42534$_MBR" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.