Database Administration (MOSC)

MOSC Banner

ORA-29858: error occurred in the execution of ODCIINDEXALTER routine

edited Jun 10, 2019 8:52PM in Database Administration (MOSC) 3 commentsAnswered


Hi all,


CREATE INDEX IDX_TABAP_1 ON TABAP (GEOLOC) INDEXTYPE IS "MDSYS"."SPATIAL_INDEX" ;

I have created spatial index using above command, but when I am going for rebuild, it is showing below error.

alter index IDX_TABAP_1 rebuild;
  
Error starting at line 1 in command:
alter index IDX_TABAP_1 rebuild
Error report:
SQL Error: ORA-29858: error occurred in the execution of ODCIINDEXALTER routine
ORA-29400: data cartridge error
ORA-01403: no data found
ORA-13249: internal error in Spatial index: [mdidxrbd]
ORA-13203: failed to read USER_SDO_GEOM_METADATA view
ORA-13203: failed to read USER_SDO_GEOM_METADATA view
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 313

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center