Re: [gdal-dev] Oracle Spatial Driver: Is it possible to append features to a table?

2020-11-14 Thread Rahkonen Jukka (MML)
Hi, Good that it works for you now. Myself I do not get an error from these either: ogr2ogr -append OCI:system/password:TEST test.shp ogr2ogr -append OCI:system/password:TEST test.shp -nln test The Oracle default to use uppercase names affects the connection string but I could not manage to

Re: [gdal-dev] Oracle Spatial Driver: Is it possible to append features to a table?

2020-11-13 Thread Kreß , Marius
Hi, As it often is with this things, it was actually pretty simple: I included the table name in the connection. It seems that this confused the program. But when I did it like you, with just username, password and server, it worked. Thanks for your help, Marius Kress

Re: [gdal-dev] Oracle Spatial Driver: Is it possible to append features to a table?

2020-11-12 Thread Rahkonen Jukka (MML)
Hi, It have not been using Oracle lately but yesterday I installed the free XE version with default values on Windows. Then I made the following simple test (I apologize all the DB admins I have been working with). ogr2ogr OCI:system/password test.shp ogr2ogr -update -append

Re: [gdal-dev] Oracle Spatial Driver: Is it possible to append features to a table?

2020-11-11 Thread jratike80
Hi, It should work. Write your two first ogr2ogr commands (the initial one and first to append) as a whole but without OCI connection details. The -nln parameter must appear in the append command if I remember right. -Jukka Rahkonen- Kreß, Marius wrote > Dear GDAL developers and users, > > I

[gdal-dev] Oracle Spatial Driver: Is it possible to append features to a table?

2020-11-11 Thread Kreß , Marius
Dear GDAL developers and users, I want to write contour polygons into an Oracle Spatial database. Because the area is quite large, I would like to calculate them in smaller boxes and write them into the table one after the other. But as far as I can see, it is not possible to append features