Problem with spatial indexes after impdp import
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