Error while importing the spatial data
myraMay 19 2011 — edited May 19 2011Hi,
I have the expdp dump from 10.2.0.4 db and I am importing it to 11.2.0.2 on another servers. I received the below error;
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-13230: failed to create temporary table [M5_13791$$] during R-tree creation
ORA-13249: Error in stmt: INSERT /*+ APPEND */ INTO M5_13791$$ select rid , min_d1, max_d1 , min_d2, max_d2 from M2_13791$$ a where (min_d1+max_d1) >
ORA-13249: Stmt-Execute Failure: INS
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:AAAS9jAARAAAYYmAAA] in spatial indexing.
ORA-13206: internal error [] while creating the spatial index
ORA-13033: Invalid data in the SDO_
Job "SYS"."SYS_IMPORT_FULL_01" completed with 688 error(s) at 16:00:41
Can anyone tell me what could be reason of all these errors and and the workaround for the same.
Thanks....