ORA-13203: failed to read USER_SDO_GEOM_METADATA view
I am upgrading a 10g db to 11g using datapump import into a new db on a new server.
One schema import reports :
ORA-39083: Object type INDEX failed to create with error:
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-13203: failed to read USER_SDO_GEOM_METADATA view
ORA-13203: failed to read USER_SDO_GEOM_METADATA view
Failing sql is:
CREATE INDEX "BTOWATCH"."GRID_GEOM_IDX1" ON "BTOWATCH"."L_GRIDREF_TO_CLUB_REGION" ("BTOWATCH"."GRIDREF_TO_GEOM"("GRIDREF")) INDEXTYPE IS "MDSYS"."SPATIAL_INDEX" PARALLEL 1
This is because it is spatial data. Initially I thought I could fix this by first of all importing the MDSYS schema into the new db before the users schema but I've done a quick comparison of MDSYS in the new 11g db and MDSYS in the old 10g db.