[gdal-dev] Re-loading non-spatial data using OGR2OGR

J. Burnson jburnson at yahoo.com
Thu Jan 26 13:59:29 EST 2012

Did you mean CPL_DEBUG ON? Here is the output:
ERROR 1: ORA-00955: name is already used by an existing object in CREATE TABLE "R_SIGN_OGR" ( OGR_FID INTEGER)
ERROR 1: Terminating translation prematurely after failed translation of layer R_Sign (use -skipfailures to skip errors)
For reference, here is the table that ogr2ogr created on the first pass:

SQL> desc r_sign_ogr
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 OGR_FID                                            NUMBER(38)
 field_1                                            VARCHAR2(2047 CHAR)
 field_2                                            VARCHAR2(2047 CHAR)

Adding MULTI_LOAD=NO had no discernible effect.

--- On Thu, 1/26/12, Chaitanya kumar CH <chaitanya.ch at gmail.com> wrote:

From: Chaitanya kumar CH <chaitanya.ch at gmail.com>
Subject: Re: [gdal-dev] Re-loading non-spatial data using OGR2OGR
To: "J. Burnson" <jburnson at yahoo.com>
Cc: gdal-dev at lists.osgeo.org
Date: Thursday, January 26, 2012, 12:10 PM

Try setting the layer creation option MULTI_LOAD to NO using -lco with ogr2ogr and the configuration option CPL_DEBUG  to OFF [1]. I hope to get at least a more usable error message.

[1]: http://trac.osgeo.org/gdal/wiki/ConfigOptions

On Thu, Jan 26, 2012 at 10:31 PM, J. Burnson <jburnson at yahoo.com> wrote:

I am trying to load a non-spatial CSV file into Oracle using ogr2ogr (GDAL 1.8.1). It works on the first attempt (when no destination table exists) but in later attempts, I get "name is already used by an existing object".
ogr2ogr -append -f OCI OCI:user/password at db -nln r_sign_ogr X:/R_Sign.csv -nlt NONE
I have tried every combination of overwrite/append/update that I can think of, as well as using "-nlt NONE". I do not have trouble re-populating spatial tables.
Any suggestions would be welcome! Thank you,
gdal-dev mailing list
gdal-dev at lists.osgeo.org

Best regards,
Chaitanya kumar CH.

17.2416N 80.1426E
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/gdal-dev/attachments/20120126/15404e4f/attachment.html

More information about the gdal-dev mailing list