Hello, I have a problem to insert an index on a geo field.
I do the following:
------------
create table geo_test1 (
id integer
,shape1 mdsys.sdo_geometry
);
insert into user_sdo_geom_metadata
(table_name, column_name, diminfo, srid)
values ('GEO_TEST1','SHAPE1', sdo_dim_array(sdo_dim_element('X',0,20,0.005), sdo_dim_element('Y',0,20,0.005) ), null );
commit;
create index idx_test1_shape on geo_test1 (shape1) indextype is mdsys.spatial_index;
------------
It gives an 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
--ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 10
The index is nevertheless created, but I want no errors of course.
I have read several articles about this error, but I cannot find a solution which resolves the problem.
I use Oracle 12c R2 on Windows Server 2016.
It is just a basic installation of Enterprise edittion, server class.
Do I need additional installatin of Oracle components ?
Could there be a problem with privileges or grants ?
Or what else could be the problem ?
Thanks in advance,
Andre