I've been successful in spatially enabling an existing table in all but 1 of the 4 steps in the 19c spatial developers guide. The final step to create the index returns generic ORA-29855 error in execution of ODCIINDEXCREATE routine.
In troubleshooting I've ensured account in my personal schema has create sequence and create table and for the steps to enable table:
#1 Altered table to create column of SDO_GEOMETRY type,
#2 updated column with SDO_GEOMETRY(2001, 32700, SD0_POINT_TYPE(X,Y,NULL)NULL,NULL);,
#3 INSERT INTO USER_SDO_GEOM_METADATA VALUES(schema.table, col, SDO_DIM_ARRAY(SDO_DIM_ELEMENT('X',-1, 1,.05), SDO_DIM_ELEMENT('Y',-1,1,.05)),32700);
COMMIT;
#4 create index: CREATE INDEX schema.indexname ON schema.table(col) INDEXTTYPE IS MDSYS.SPATIAL_INDEX_V2 LOCAL;
The spatial data column is showing data in each field 'MDSYS.SDO_GEOMETRY(2001, 32700, MDSYS.SDO_POINT_TYPE(xvalue, yvalue, NULL), NULL, NULL)
can you provide advise on additoinal troubleshooting or possible solution