<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
According to that code it should work:</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<a href="https://github.com/OSGeo/gdal/blob/70a2ec1795c3e01aeaf1ac3c0f7c69a3f0fa2ca5/gdal/ogr/ogrsf_frmts/oci/ogrocisession.cpp#L316" id="LPlnk">https://github.com/OSGeo/gdal/blob/70a2ec1795c3e01aeaf1ac3c0f7c69a3f0fa2ca5/gdal/ogr/ogrsf_frmts/oci/ogrocisession.cpp#L316</a><br>
</div>
<div class="_Entity _EType_OWALinkPreview _EId_OWALinkPreview _EReadonly_1"></div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Ticket:</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<a href="https://trac.osgeo.org/gdal/ticket/6866" id="LPlnk474099">https://trac.osgeo.org/gdal/ticket/6866</a></div>
<div id="appendonsend"></div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> gdal-dev <gdal-dev-bounces@lists.osgeo.org> on behalf of Victoria Ponz-Sarvise <vponz-sarvise@forsk.com><br>
<b>Sent:</b> Tuesday, September 15, 2020 9:03 AM<br>
<b>To:</b> gdal-dev@lists.osgeo.org <gdal-dev@lists.osgeo.org><br>
<b>Subject:</b> [gdal-dev] ogr2ogr with ORACLE driver: limitation on table name size?</font>
<div> </div>
</div>
<style>
<!--
@font-face
{font-family:"Cambria Math"}
@font-face
{font-family:Calibri}
p.x_MsoNormal, li.x_MsoNormal, div.x_MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif}
.x_MsoChpDefault
{font-size:10.0pt}
@page WordSection1
{margin:1.0in 1.0in 1.0in 1.0in}
div.x_WordSection1
{}
-->
</style>
<div lang="EN-US" link="#0563C1" vlink="#954F72">
<div class="x_WordSection1">
<p class="x_MsoNormal">Hi,</p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal">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.
</p>
<p class="x_MsoNormal">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.</p>
<p class="x_MsoNormal">The oracle database I’m using is 12.2, but ogr2ogr command truncates my table names to 30 chars.
</p>
<p class="x_MsoNormal">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?
</p>
<p class="x_MsoNormal">I am using GDAL 2.4.3</p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal">Thanks for your answer!</p>
<p class="x_MsoNormal">Regards </p>
<p class="x_MsoNormal">Victoria</p>
</div>
</div>
</body>
</html>