I hit with that error message during the export&import process on 12c database on Linux

While I am checking import log, I noticed below error message:

ORA-13249: Error in R-tree: [mdrcrtscrt]
ORA-13231: failed to create index table [MY_OBJECT$] during R-tree creation
ORA-13249: Stmt-Execute Failure: CREATE TABLE "MY_SCHEMA"."MY_OBJECT$"(NODE_ID NUMBER,NODE_LEVEL NUMBER,INFO BLOB) LOB (INFO) STORE 
ORA-39083: Object type INDEX:"MY_SCHEMA"."GI_LOCATION_1" 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

While I try to create an index with sys user I hit below errors:

SQL> CREATE INDEX MY_SCHEMA.GI_LOCATION_1 ON MY_SCHEMA.GIS_TABLE
(LOCATION)
INDEXTYPE IS MDSYS.SPATIAL_INDEX
NOPARALLEL;

ERROR at line 1:
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 [MY_TABLE$] during R-tree creation
ORA-13249: Stmt-Execute Failure: CREATE TABLE "MY_SCHEMA"."MY_TABLE$"(NODE_ID NUMBER,NODE_LEVEL NUMBER,INFO BLOB) LOB (INFO) STORE AS SECUREFILE (NOCACHE) PCTFREE 2 TABLESPACE USERS NOLOGGING
ORA-29400: data cartridge error
ORA-01031: insufficient privileges
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 10

So first Grant to your schema

SQL> grant unlimited tablespace to MY_SCHEMA;
Grant succeeded.

SQL> grant CREATE TABLE to MY_SCHEMA;
Grant succeeded.

SQL> grant CREATE SEQUENCE to MY_SCHEMA;
Grant succeeded.

Then, try to recreate an index

SQL> DROP INDEX MY_SCHEMA.GI_LOCATION_1;
Index dropped.

SQL> CREATE INDEX MY_SCHEMA.GI_LOCATION_1 ON MY_SCHEMA.GIS_TABLE
(LOCATION)
INDEXTYPE IS MDSYS.SPATIAL_INDEX
NOPARALLEL;

Index created.
Advertisements