ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine (Doc ID 2357869.1)

Last updated on SEPTEMBER 12, 2022

Applies to:

Goal

Executed dbtools upgrade Script facing below error

Even when tried to execute the script which inserts the records in the user_sdo_geom_metadata table. Ensured the records are inserted and attempted to create the Index. The same error is displayed.
Error starting at line : 44 in command -
CREATE INDEX uimev11.I_TPLGYDG_GEOMETRY ON uimev11.TOPOLOGYEDGE (GEOMETRY)INDEXTYPE IS MDSYS.SPATIAL_INDEX
Error at Command Line : 44 Column : 22
Error report -
SQL 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 R-tree: [mdrcrtscrt]
ORA-13231: failed to create index table [MDRT_3B54C$] during R-tree creation
ORA-13249: Stmt-Execute Failure: CREATE TABLE "UIMEV11".MDRT_3B54C$ (NODE_ID NUMBER, NODE_LEVEL NUMBER, INFO BLOB) LOB (INFO) STORE AS (NOCACHE) PCTFREE 2
ORA-29400: data cartridge error
ORA-01031: insufficient privileges
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 10
29855. 00000 - "error occurred in the execution of ODCIINDEXCREATE routine"
*Cause: Failed to successfully execute the ODCIIndexCreate routine.
*Action: Check to see if the routine has been coded correctly.
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.