[gdal-dev] Limiting Oracle layers to the tables of a given schema
Vautour, André (INT)
Andre.Vautour at Teledyne.com
Thu Apr 13 11:52:58 PDT 2017
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.
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the gdal-dev