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
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 |