John, Check if it works if you replace "-nln r_sign_ogr" with "-nln R_SIGN_OGR"
On Fri, Jan 27, 2012 at 12:29 AM, J. Burnson <jburn...@yahoo.com> wrote: > Hi, > Did you mean CPL_DEBUG ON? Here is the output: > > OCI: Prepare(CREATE TABLE "R_SIGN_OGR" ( OGR_FID INTEGER)) > 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. > John > > --- On *Thu, 1/26/12, Chaitanya kumar CH <chaitanya...@gmail.com>* wrote: > > > From: Chaitanya kumar CH <chaitanya...@gmail.com> > Subject: Re: [gdal-dev] Re-loading non-spatial data using OGR2OGR > To: "J. Burnson" <jburn...@yahoo.com> > Cc: gdal-dev@lists.osgeo.org > Date: Thursday, January 26, 2012, 12:10 PM > > > John, > 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 > <jburn...@yahoo.com<http://us.mc1809.mail.yahoo.com/mc/compose?to=jburn...@yahoo.com> > > wrote: > > Hi, > 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@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, > John > > _______________________________________________ > gdal-dev mailing list > gdal-dev@lists.osgeo.org<http://us.mc1809.mail.yahoo.com/mc/compose?to=gdal-dev@lists.osgeo.org> > http://lists.osgeo.org/mailman/listinfo/gdal-dev > > > > > -- > Best regards, > Chaitanya kumar CH. > > +91-9494447584 > 17.2416N 80.1426E > > -- Best regards, Chaitanya kumar CH. +91-9494447584 17.2416N 80.1426E
_______________________________________________ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
