Problem with spatial indexes after impdp import

From: <moriacmick_at_gmail.com>
Date: Mon, 18 May 2015 22:14:46 -0700 (PDT)
Message-ID: <f14d94b7-8698-4f5e-ad03-5cbc1dab9ac1_at_googlegroups.com>



I am doing an impdp import into a new database.

I am getting some errors indicating that there are problems with spatial indexes.

However the log file (see below) does not appear to specify which spatial index is causing the problem.

Is there some way of determining what indexes are at fault and how I can identify corrective actions to take?

Thanks in advance.

Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/DOMAIN_INDEX/INDEX

ORA-39083: Object type INDEX failed to create with error:

ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine

ORA-13249: internal error in Spatial index: [mdidxrbd]

ORA-13249: Error in Spatial index: index build failed

ORA-13249: Error in spatial index: [mdrcrtxfergm]

ORA-13249: Error in spatial index: [mdpridxtxfergm]

ORA-13200: internal error [ROWID:AAAVrhAAHAABCLVAAG] in spatial indexing.

ORA-13206: internal error [] while creating the spatial index

ORA-13033: Invalid data in the SDO_EL

ORA-39083: Object type INDEX failed to create with error:

ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine

ORA-13249: internal error in Spatial index: [mdidxrbd]

ORA-13249: Error in Spatial index: index build failed

ORA-13249: Error in spatial index: [mdrcrtxfergm]

ORA-13249: Error in spatial index: [mdpridxtxfergm]

ORA-13200: internal error [ROWID:AAAVqWAAJAABH2UAAN] in spatial indexing.

ORA-13206: internal error [] while creating the spatial index

ORA-13033: Invalid data in the SDO_EL Received on Tue May 19 2015 - 07:14:46 CEST

Original text of this message