[gdal-dev] When and why ogrinfo sends update for Oracle?

[Stefano Iacovella]

2012/8/22 Rahkonen Jukka <Jukka.Rahkonen at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20120822/c4850a81/attachment-0001.html>