2012/8/22 Rahkonen Jukka <jukka.rahko...@mmmtike.fi> > Stefano Iacovella wrote: > > > >> I guess that meaning is to check all the metadata rows from the > >> ALL_SDO_GEOM_METADATA view which are referring to the queried table. > >> There can be several rows created be different Oracle users. Next the > >> maximum BBOX is constructed and that is updated into > >> USER_SDO_GEOM_METADATA view. > > > It seems to me that first statement should include an OWNER filter in > the WHERE clause, or it will fetch all records for table with same name and > same geometric filedname. > > Not really, it is normal in managed envinronment that db admins or data > managers are creating and updating the tables but reporting is done with > minimal rights. So reading ALL_SDO_GEOM_METADATA does make sense.
Yes but you may find duplicate rows for tableName if user 1 owns tableGeom and user 2 owns tableGeom and the geometry column name is the same.
_______________________________________________ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev