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

Reply via email to