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

[Chaitanya kumar CH]

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 <jburnson at 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.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
>
>
> 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 <jburnson at yahoo.com<http://us.mc1809.mail.yahoo.com/mc/compose?to=jburnson@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 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,
> John
>
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/gdal-dev/attachments/20120127/708f121e/attachment-0001.html