Problem with spatial indexes after impdp import

moria...@gmail.com

unread,

May 19, 2015, 1:14:53 AM5/19/15

to

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

moria...@gmail.com

unread,

May 19, 2015, 1:31:15 AM5/19/15

to

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

Mladen Gogala

unread,

May 19, 2015, 3:08:14 AM5/19/15

to

On Mon, 18 May 2015 22:14:46 -0700, moriacmick wrote:

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

The phrase "internal error" is translated into the English language as
"call support".

--
Mladen Gogala
The Oracle Whisperer
http://mgogala.byethost5.com

joel garry

unread,

May 19, 2015, 12:03:52 PM5/19/15

to

You can search for the errors on MOS, there are both bugs and feature changes. If none of them are your situation, do as Mladen suggested.

You can get a text version of what the impdp is trying to do with the sqlfile parameter and examine the index creation command for some of those situation.

jg
--
@home.com is bogus.
http://uk.businessinsider.com/salesforce-ceo-marc-benioff-finds-a-way-to-take-a-jab-at-oracle-during-a-berkeley-graduation-speech-2015-5

Mark D Powell

unread,

May 19, 2015, 2:37:33 PM5/19/15

to

moria, you did not post your impdp command. By any chance are you trying to remap the tablespaces? The tablespace name for a domain index is part of the storage reference and cannot be remapped by impdp. You have to extract the index DDL and build it manually after editing.

If you are not remapping then opening a ticket with support may well be your best bet, but someone might spot something if you post the full impdp command in use.

HTH -- Mark D Powell --