In Oracle 11g one must register the layer with geometries in USER_SDO_GEOM_METADATA view before creating a spatial index and one must create a spatial index before using spatial operators in queries. I know that this has changed and now spatial index is not necessary. But why registering the layer in SQL Oracle Live (now version 19 of database) provides an error and attempt to create a spatial index provides an error? After the attempt of inserting metadata to USER_SDO_GEOM_METADATA I always get something like
ORA-13223: duplicate entry for OSWIETLENIE.GEOMETRIA in SDO_GEOM_METADATA ORA-06512: at "MDSYS.MD", line 1723 ORA-06512: at "MDSYS.MDERR", line 17 ORA-06512: at "MDSYS.SDO_GEOM_TRIG_INS1", line 69 ORA-06512: at "SYS.DBMS_SQL", line 1721
select * from user_sdo_geom_metadata;
always gives "no data found",
and the attempt of creating a spatial index gives
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 10
as if the layer had no registration in user_sdo_geom_metadata.
Why is it so? Something goes automatically but is not visible in user_sdo_geom_metadata? Is it something in Oracle SQL Live?