<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;"><DIV>Hi,</DIV>
<DIV>Did you mean CPL_DEBUG ON? Here is the output:</DIV>
<DIV> </DIV>
<DIV><FONT face="courier, monaco, monospace, sans-serif">OCI: Prepare(CREATE TABLE "R_SIGN_OGR" ( OGR_FID INTEGER))<BR>ERROR 1: ORA-00955: name is already used by an existing object in CREATE TABLE "R_SIGN_OGR" ( OGR_FID INTEGER)<BR>ERROR 1: Terminating translation prematurely after failed translation of layer R_Sign (use -skipfailures to skip errors)</FONT></DIV>
<DIV><FONT face="courier, monaco, monospace, sans-serif"></FONT> </DIV><FONT face="courier, monaco, monospace, sans-serif">
<DIV><FONT face="arial, helvetica, sans-serif">For reference, here is the table that ogr2ogr created on the first pass:</FONT></DIV>
<DIV><BR></DIV></FONT>
<DIV><FONT face="courier, monaco, monospace, sans-serif">SQL> desc r_sign_ogr<BR> Name Null? Type<BR> ----------------------------------------- -------- ----------------------------</FONT></DIV>
<DIV><FONT face="courier, monaco, monospace, sans-serif"> OGR_FID NUMBER(38)<BR> field_1 VARCHAR2(2047 CHAR)<BR> field_2 VARCHAR2(2047 CHAR)<BR></DIV></FONT>
<DIV>Adding MULTI_LOAD=NO had no discernible effect.</DIV>
<DIV>John</DIV>
<DIV><BR>--- On <B>Thu, 1/26/12, Chaitanya kumar CH <I><chaitanya.ch@gmail.com></I></B> wrote:<BR></DIV>
<BLOCKQUOTE style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: rgb(16,16,255) 2px solid"><BR>From: Chaitanya kumar CH <chaitanya.ch@gmail.com><BR>Subject: Re: [gdal-dev] Re-loading non-spatial data using OGR2OGR<BR>To: "J. Burnson" <jburnson@yahoo.com><BR>Cc: gdal-dev@lists.osgeo.org<BR>Date: Thursday, January 26, 2012, 12:10 PM<BR><BR>
<DIV id=yiv589108456>John,<BR>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.<BR><BR>[1]: <A href="http://trac.osgeo.org/gdal/wiki/ConfigOptions" target=_blank rel=nofollow>http://trac.osgeo.org/gdal/wiki/ConfigOptions</A><BR><BR>
<DIV class=yiv589108456gmail_quote>On Thu, Jan 26, 2012 at 10:31 PM, J. Burnson <SPAN dir=ltr><<A href="http://us.mc1809.mail.yahoo.com/mc/compose?to=jburnson@yahoo.com" target=_blank rel=nofollow ymailto="mailto:jburnson@yahoo.com">jburnson@yahoo.com</A>></SPAN> wrote:<BR>
<BLOCKQUOTE class=yiv589108456gmail_quote style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<TABLE cellSpacing=0 cellPadding=0 border=0>
<TBODY>
<TR>
<TD vAlign=top>
<DIV>
<TABLE cellSpacing=0 cellPadding=0 border=0>
<TBODY>
<TR>
<TD style="FONT-SIZE: 10pt; FONT-FAMILY: arial">
<DIV>Hi,</DIV>
<DIV>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".</DIV>
<DIV> </DIV>
<DIV>ogr2ogr -append -f OCI OCI:user/password@db -nln r_sign_ogr X:/R_Sign.csv -nlt NONE</DIV>
<DIV> </DIV>
<DIV>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.</DIV>
<DIV> </DIV>
<DIV>Any suggestions would be welcome! Thank you,</DIV>
<DIV>John</DIV></TD></TR></TBODY></TABLE></DIV></TD></TR></TBODY></TABLE><BR>_______________________________________________<BR>gdal-dev mailing list<BR><A href="http://us.mc1809.mail.yahoo.com/mc/compose?to=gdal-dev@lists.osgeo.org" target=_blank rel=nofollow ymailto="mailto:gdal-dev@lists.osgeo.org">gdal-dev@lists.osgeo.org</A><BR><A href="http://lists.osgeo.org/mailman/listinfo/gdal-dev" target=_blank rel=nofollow>http://lists.osgeo.org/mailman/listinfo/gdal-dev</A><BR></BLOCKQUOTE></DIV><BR><BR clear=all><BR>-- <BR>Best regards,<BR>Chaitanya kumar CH.<BR><BR>+91-9494447584<BR>17.2416N 80.1426E<BR></DIV></BLOCKQUOTE></td></tr></table>