Hello,
I am new to Oracle Spatial and maybe it's a stupid question, but when I create a spatial index for one geo table, I always have to manually insert a row into the USER_SDO_GEOM_METADATA table.The DIMINFO table contains the bounding box, which are in my case the min/max X/Y coordinates (Long/Lat) of the entire geo table.
The SDO_GEOMETRY column in my geo table contains some polygons. How can I automatically query the geo table to return the desired max/min X/Y coordinates? I am looking for something like SELECT maxX(geo_data),.... FROM geo_table. Is this possible?
Thanks!