Database Software

I want to change the sdo_gtype value in a layer from 2 to 2002.

I issue the following command:

update traffic a set a.geometry.sdo_gtype = 2002;

I get the following error:

ERROR at line 1:
ORA-29877: failed in the execution of the ODCIINDEXUPDATE routine
ORA-13051: failed to initialize spatial object
ORA-06512: at "MDSYS.SDO_INDEX_METHOD", line 8
ORA-06512: at "MDSYS.SDO_IDX", line 86
ORA-06512: at "MDSYS.SDO_INDEX_METHOD", line 83
ORA-06512: at line 1

I drop the spatial index:

drop index traffic_spx;

I then update the sdo_gtype.

But I cannot recreate the spatial index:

create index traffic_idx on lrsxtest.traffic (geometry)
indextype is mdsys.spatial_index
*
ERROR at line 1:
ORA-29855: error occurred in the execution of ODCIINDEXCREATE
routine

Does anyone know why this is happening?

I am running 8.1.7.2.1 on NT.

Thanks

Dave