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

Ivan Lucena lucena_ivan at hotmail.com
Thu Apr 13 12:41:44 PDT 2017

According to the doc:
"If the list of tables is not provided, then all tables appearing in ALL_SDO_GEOM_METADATA will be treated by OGR as layers with the table names as the layer names. Non-spatial tables or spatial tables not listed in the ALL_SDO_GEOM_METADATA table are not accessible unless explicitly listed in the datasource name. Even in databases where all desired layers are in the ALL_SDO_GEOM_METADATA table, it may be desirable to list only the tables to be used as this can substantially reduce initialization time in databases with many tables."

You might avoiding that issue by entering an empty table list when loading, like in "OCI:usr/pwd at db:". Please note the ":" at the end.

On Apr 13, 2017, at 2:54 PM, Vautour, André (INT) <Andre.Vautour at Teledyne.com<mailto:Andre.Vautour at Teledyne.com>> 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>.*

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


gdal-dev mailing list
gdal-dev at lists.osgeo.org<mailto:gdal-dev at lists.osgeo.org>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20170413/fa42fd83/attachment-0001.html>

More information about the gdal-dev mailing list