<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;"><DIV>Hi,</DIV>
<DIV> </DIV>
<DIV>Later tests suggest that ogr2ogr is checking ALL_SDO_GEOM_METADATA for this table, even though the table is non-spatial (and declared as such). The lack of a record there is a trigger for ogr to create the table de novo.</DIV>
<DIV> </DIV>
<DIV>I am able to trick the program by manually registering a (fictitious) shape column for the table in SDO_GEOM_METADATA. Thereafter, ogr2ogr has no trouble loading and re-loading. Not ideal but progress of a sort!</DIV>
<DIV> </DIV>
<DIV>John<BR><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=yiv48887990>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=yiv48887990gmail_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=yiv48887990gmail_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>