Opened 17 years ago

Closed 14 years ago

#1624 closed defect (fixed)

ogr2ogr OCI -append -update fails

Reported by: lozuna Owned by: ilucena
Priority: normal Milestone:
Component: OGR_SF Version: unspecified
Severity: normal Keywords: oracle oci
Cc: warmerdam

Description

I am appending vmap features into oracle spatial

ogr2ogr -f OCI OCI:vmap/vmap@oceana:LIBREF_LIBREF____LINE gltp:/vrf/home/oracle/vmap1_99/v1099/noamer/lib_099 'libref@libref(*)_line' -update -append ERROR 1: Layer LIBREF_LIBREFLINE already exists, CreateLayer failed. Use the layer creation option OVERWRITE=YES to replace it. ERROR 1: Terminating translation prematurely after failed translation of layer libref@libref(*)_line

Fails as does

ogr2ogr -f OCI OCI:vmap/vmap@oceana:LIBREF_LIBREF____LINE gltp:/vrf/home/oracle/vmap1_99/v1099/noamer/lib_099 'libref@libref(*)_line' -append ERROR 1: Layer LIBREF_LIBREFLINE already exists, CreateLayer failed. Use the layer creation option OVERWRITE=YES to replace it. ERROR 1: Terminating translation prematurely after failed translation of layer libref@libref(*)_line

ogr2ogr -f OCI OCI:vmap/vmap@oceana:LIBREF_LIBREF____LINE gltp:/vrf/home/oracle/vmap1_99/v1099/noamer/lib_099 'libref@libref(*)_line' -update -append ERROR 1: Layer LIBREF_LIBREFLINE already exists, CreateLayer failed. Use the layer creation option OVERWRITE=YES to replace it. ERROR 1: Terminating translation prematurely after failed translation of layer libref@libref(*)_line

Fails as does

ogr2ogr -f OCI OCI:vmap/vmap@oceana gltp:/vrf/home/oracle/vmap1_99/v1099/noamer/lib_099 'libref@libref(*)_line' -append ERROR 1: Layer LIBREF_LIBREFLINE already exists, CreateLayer failed. Use the layer creation option OVERWRITE=YES to replace it. ERROR 1: Terminating translation prematurely after failed translation of layer libref@libref(*)_line

OGDI version 3.1.5 gdal version 1.4.1 proj version 4.5.0

oracle oci version 10gR2

built on Linux <myhost> 2.6.9-11.EL #1 Wed Jun 8 16:59:52 CDT 2005 i686 athlon i386 GNU/Linux

Centos

Initial create works fine - the append fails -

Thank You

Lettie

Change History (8)

comment:1 by warmerdam, 17 years ago

Cc: warmerdam added
Component: defaultOGR_SF
Keywords: oracle oci added
Milestone: 1.4.3
Owner: changed from warmerdam to Mateusz Łoskot
Priority: highnormal

Lets try and address this for 1.4.3 if possible.

comment:2 by warmerdam, 17 years ago

Milestone: 1.4.31.5.0

Moving to 1.5 to lighten 1.4.3 load.

comment:3 by warmerdam, 16 years ago

Milestone: 1.5.01.5.1

OCI issues deferred to 1.5.1.

comment:4 by mloskot, 16 years ago

Status: newassigned

comment:5 by warmerdam, 14 years ago

Milestone: 1.5.4
Owner: changed from Mateusz Łoskot to warmerdam
Status: assignednew

reassigning to me for eventually handling, not likely for 1.7 release.

comment:6 by warmerdam, 14 years ago

Owner: changed from warmerdam to ilucena

comment:7 by ilucena, 14 years ago

Fixed on ticket #1960

comment:8 by ilucena, 14 years ago

Resolution: fixed
Status: newclosed
Note: See TracTickets for help on using tickets.