[gdal-dev] Limiting Oracle layers to the tables of a given schema
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>.*
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.
Spatialys - Geospatial professional services
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the gdal-dev