[gdal-dev] [EXTERNAL] ogr oracle unable to create index

[Smith, Michael ERDC-RDE-CRREL-NH]

Martin,

The error indicates that there already is an index by that name. If you
drop the index manually, then the spatial index will get created.

Mike

-- 
Michael Smith

US Army Corps
Remote Sensing GIS/Center



On 4/15/14, 4:24 PM, "Martin Landa" <landa.martin at gmail.com> wrote:

>Hi all,
>
>when playing with Oracle I discovered that `ogr2ogr -f OCI` fails to
>create a spatial index.
>
>Deleting directly.
>OCI: Prepare(CREATE INDEX "OBCE_IDX" ON OBCE("ORA_GEOMETRY") INDEXTYPE
>IS MDSYS.SPATIAL_INDEX )
>ERROR 1: ORA-00955: name is already used by an existing object
> in CREATE INDEX "OBCE_IDX" ON OBCE("ORA_GEOMETRY") INDEXTYPE IS
>MDSYS.SPATIAL_INDEX
>OCI: Prepare(DROP INDEX "OBCE_IDX")
>
>Any similar experience or ideas what could be wrong (testing GDAL from
>trunk on MS Windows)? Thanks in advance, Martin
>
>-- 
>Martin Landa * http://geo.fsv.cvut.cz/gwiki/Landa
>_______________________________________________
>gdal-dev mailing list
>gdal-dev at lists.osgeo.org
>http://lists.osgeo.org/mailman/listinfo/gdal-dev