[gdal-dev] Limiting Oracle layers to the tables of a given schema

Even Rouault even.rouault at spatialys.com
Thu Apr 13 12:43:01 PDT 2017


On jeudi 13 avril 2017 18:52:58 CEST Vautour, André (INT) wrote:
> Hi all,
> 
> I started playing with the Oracle Spatial (OCI) vector driver and was
> surprised that the default behaviour is to look for all the tables listed
> in ALL_SDO_GEOM_METADATA.
> 
> I would have expected it to use all the tables in the schema (user) that was
> provided, so, essentially, to query USER_SDO_GEOM_METADATA. I think it
> would make sense to support only listing the tables in a given schema.
> 
> Assuming that the default behaviour is to remain unchanged, I am considering
> a couple of options:
> 
> 1.       Add something like a LIST_ONLY_USER_TABLES dataset open option,
> which would query USER_SDO_GEOM_METADATA instead of ALL_SDO_GEOM_METADATA.
> 
> 2.       Add a SCHEMA dataset open option which would query
> ALL_SDO_GEOM_METADATA WHERE OWNER = '<value_of_option>'
> 
> 3.       Add wildcard support to the tables list, so that a user can specify
> something like <a_schema>.*,<another_schema>.*

André,

In the PostgreSQL driver, we have

  <Option name="SCHEMAS" type="string" description="Restricted sets of schemas to 
explore (comma separated)" />

Sothat would be something close to your 3.

Even

-- 
Spatialys - Geospatial professional services
http://www.spatialys.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20170413/eaecfc4d/attachment.html>


More information about the gdal-dev mailing list