[gdal-dev] OCI driver and -lco OVERWRITE=yes

Jukka Rahkonen jukka.rahkonen at mmmtike.fi
Tue Oct 13 06:48:29 EDT 2009


Hi,

I tried to follow the example from http://gdal.org/ogr/drv_oci.html but but -lco
OVERWRITE=yes does not overwrite anything for me. I have to drop the table
manually first. It is not about user rights, I can drop the table as the same
user from SQL*Plus. I quess that OVERWRITE=yes should drop the table and indexes
and delete the corresponding line from USER_SDO_GEOM_METADATA. However, ogr2ogr
with this option gives me just:

FAILED: Layer test already exists, and -append not specified.
        Consider using -append, or -overwrite.
ERROR 1: Terminating translation prematurely after failed
translation of layer test

I did consider using -overwrite, but it is not supported with OCI driver.
Ogr2ogr message:
 ERROR 6: DeleteLayer() not supported by this data source.
DeleteLayer() failed when overwrite requested.
No surprise, I bet that because of this there is the -lco OVERWRITE=yes option.
But is fails as well.

Ogr2ogr I am using comes from MS4W 2.2.8.

One question about OCI-driver: Is is possible to give the name of the spatial
index that will be created? I have succeeded in giving the tablespace for index
with INDEX_PARAMETERS but index name is not a parameter in Oracle CREATE INDEX,
it is given before the parameters.

-Jukka Rahkonen-



More information about the gdal-dev mailing list