Re: Problem with spatial indexes after impdp import

On Monday, May 18, 2015 at 10:31:15 PM UTC-7, moria..._at_gmail.com wrote:
> 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

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

-- 
_at_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