[Gdal-dev] OGR spatial indexes in Oracle

Frank Warmerdam warmerdam at pobox.com
Fri Oct 15 10:50:30 EDT 2004


bluecarto at free.fr wrote:
> That works, although this limits in some way.
> Is there any way to use the views in oracle with OGR ?

Pierre,

Currently the OCI driver does the following query to get the list of
tables to be treated as layers:

   SELECT TABLE_NAME, COLUMN_NAME, SRID, OWNER FROM ALL_SDO_GEOM_METADATA

If views appear in ALL_SDO_GEOM_METADATA then they should be usable as
layers.  If not, they wont.

Best regards,
-- 
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up   | Frank Warmerdam, warmerdam at pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush    | Geospatial Programmer for Rent




More information about the Gdal-dev mailing list