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é
_______________________________________________ gdal-dev mailing list gdal-dev@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/gdal-dev
