John,<br><br>Check if it works if you replace "-nln r_sign_ogr" with "-nln R_SIGN_OGR"<br><br><div class="gmail_quote">On Fri, Jan 27, 2012 at 12:29 AM, J. Burnson <span dir="ltr"><<a href="mailto:jburnson@yahoo.com">jburnson@yahoo.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><table border="0" cellpadding="0" cellspacing="0"><tbody><tr><td style="font:inherit" valign="top"><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>
</font></div>
<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><<a href="mailto:chaitanya.ch@gmail.com" target="_blank">chaitanya.ch@gmail.com</a>></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 <<a href="mailto:chaitanya.ch@gmail.com" target="_blank">chaitanya.ch@gmail.com</a>><br>Subject: Re: [gdal-dev] Re-loading non-spatial data using OGR2OGR<br>
To: "J. Burnson" <<a href="mailto:jburnson@yahoo.com" target="_blank">jburnson@yahoo.com</a>><br>Cc: <a href="mailto:gdal-dev@lists.osgeo.org" target="_blank">gdal-dev@lists.osgeo.org</a><br>Date: Thursday, January 26, 2012, 12:10 PM<div>
<div class="h5"><br><br>
<div>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" rel="nofollow" target="_blank">http://trac.osgeo.org/gdal/wiki/ConfigOptions</a><br>
<br>
<div>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" rel="nofollow" target="_blank">jburnson@yahoo.com</a>></span> wrote:<br>
<blockquote style="PADDING-LEFT:1ex;MARGIN:0px 0px 0px 0.8ex;BORDER-LEFT:#ccc 1px solid">
<table border="0" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td valign="top">
<div>
<table border="0" cellpadding="0" cellspacing="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" rel="nofollow" target="_blank">gdal-dev@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/gdal-dev" rel="nofollow" target="_blank">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><a href="tel:%2B91-9494447584" value="+919494447584" target="_blank">+91-9494447584</a><br>17.2416N 80.1426E<br></div></div></div></blockquote></td></tr></tbody></table></blockquote></div><br><br clear="all"><br>-- <br>
Best regards,<br>Chaitanya kumar CH.<br><br>+91-9494447584<br>17.2416N 80.1426E<br>