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

Thu Apr 13 11:52:58 PDT 2017

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>.*

Also, it might be important to note that DeleteLayer and ValidateLayer only currently work off of USER_SDO_GEOM_METADATA.

Thoughts?
André

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20170413/15bd7f3a/attachment.html>