Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problem with spatial indexes after impdp import

user6502667May 19 2015 — edited May 19 2015

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

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 16 2015
Added on May 19 2015
2 comments
1,306 views