[Gdal-dev] OGR spatial indexes in Oracle

[bluecarto at free.fr]

> 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,

This way I can produce working views. Hopelessly, the spatial index of the
parent table is useless, and I can't create any one on the view :

create index Q_VIEW_PARCELLE on view_parcelle(geometry)
                                *

ERROR at line 1:
ORA-01702: a view is not appropriate here

Any idea ?

Regards.