[gdal-dev] ogr2ogr with ORACLE driver: limitation on table name size?

Victoria Ponz-Sarvise vponz-sarvise at forsk.com
Tue Sep 15 06:03:11 PDT 2020


Hi,

I'm using ogr2ogr to upload shapefiles in an Oracle database, and I would like to know if there is a limitation of the number of characters in the created tables names.
In Oracle, until v12.2, the table names where limited to 30 bytes, and after that it is possible to create tables with names 128 bytes long.
The oracle database I'm using is 12.2, but ogr2ogr command truncates my table names to 30 chars.
I can not find in the documentation if there is a limitation in table names sizes in ogr. Can you please tell me if ogr2ogr is able to create table names longer than 30 bytes?
I am using GDAL 2.4.3

Thanks for your answer!
Regards
Victoria
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20200915/34aad427/attachment.html>


More information about the gdal-dev mailing list