Re: Problem with spatial indexes after impdp import

On Tuesday, May 19, 2015 at 3:14:53 PM UTC+10, moria..._at_gmail.com wrote:
> 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

Apologies, I forgot to mention that the export file is from a 10.2.0.3.0 database and I am importing into a 11.2.0.4.0 database Received on Tue May 19 2015 - 07:31:11 CEST