<div dir="ltr">Hi Stephan, all, <div><br></div><div>I had posted a question about DB connections, a few weeks ago:<br><br></div><div><a href="https://lists.osgeo.org/pipermail/qgis-user/2023-November/053641.html">https://lists.osgeo.org/pipermail/qgis-user/2023-November/053641.html</a></div><div><br></div><div>You can help, maybe... </div><div>Is there any chance to get a connection with an Oracle Proxy user, in QGis? </div><div>I'm afraid there's not...</div><div><br></div><div>thank you</div><div>Fabio</div><div><br></div><div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Il giorno mer 20 dic 2023 alle ore 08:08 Huesmann, Michaela via QGIS-User <<a href="mailto:qgis-user@lists.osgeo.org">qgis-user@lists.osgeo.org</a>> ha scritto:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div class="msg-4844318988259702093">
<div lang="DE">
<div class="m_-4844318988259702093WordSection1">
<p class="MsoNormal">Hi Stefan,<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">thank you for that hint. It helps a lot!<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Best regards,<u></u><u></u></p>
<p class="MsoNormal">Michaela<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div style="border-right:none;border-bottom:none;border-left:none;border-top:1pt solid rgb(225,225,225);padding:3pt 0cm 0cm">
<p class="MsoNormal"><b><span>Von:</span></b><span> QGIS-User <<a href="mailto:qgis-user-bounces@lists.osgeo.org" target="_blank">qgis-user-bounces@lists.osgeo.org</a>>
<b>Im Auftrag von </b>Stefan Giese (WhereGroup) via QGIS-User<br>
<b>Gesendet:</b> Freitag, 15. Dezember 2023 08:44<br>
<b>An:</b> <a href="mailto:qgis-user@lists.osgeo.org" target="_blank">qgis-user@lists.osgeo.org</a><br>
<b>Betreff:</b> Re: [Qgis-user] Oracle DB connection in QGIS<u></u><u></u></span></p>
</div>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<p>Hi Michaela,<span><u></u><u></u></span></p>
<p>did you check theese options?<u></u><u></u></p>
<ul type="disc">
<li class="MsoNormal">
"Use estimated table metadata" <u></u><u></u></li><li class="MsoNormal">
"Only look for user tables"<u></u><u></u></li></ul>
<p><img width="579" height="167" style="width: 6.0312in; height: 1.7395in;" id="m_-4844318988259702093_x0000_i1025" src="cid:ii_18c8634891b4cff311"><u></u><u></u></p>
<div>
<p class="MsoNormal">best regards <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">Stefan<u></u><u></u></p>
</div>
<div>
<pre>Stefan Giese<u></u><u></u></pre>
<pre>Projektleiter/Consultant<u></u><u></u></pre>
<pre>**********************************<u></u><u></u></pre>
<pre>Where2B Konferenz 2023<u></u><u></u></pre>
<pre>14. Dezember 2023 in Bonn und Online<u></u><u></u></pre>
<pre><a href="https://where2b-conference.com/" target="_blank">https://where2b-conference.com/</a><u></u><u></u></pre>
<pre>**********************************<u></u><u></u></pre>
<pre>WhereGroup GmbH<u></u><u></u></pre>
<pre>Schwimmbadstr. 2<u></u><u></u></pre>
<pre>79100 Freiburg<u></u><u></u></pre>
<pre>Germany<u></u><u></u></pre>
<pre><u></u> <u></u></pre>
<pre>Tel.: +49 (0)761 / 519 102 - 61<u></u><u></u></pre>
<pre>Fax: +49 (0)761 / 519 102 - 11<u></u><u></u></pre>
<pre><u></u> <u></u></pre>
<pre><a href="mailto:stefan.giese@wheregroup.com" target="_blank">stefan.giese@wheregroup.com</a><u></u><u></u></pre>
<pre><a href="http://www.wheregroup.com" target="_blank">www.wheregroup.com</a><u></u><u></u></pre>
<pre>Geschäftsführer:<u></u><u></u></pre>
<pre>Olaf Knopp, Peter Stamm<u></u><u></u></pre>
<pre>Amtsgericht Bonn, HRB 9885<u></u><u></u></pre>
</div>
<div>
<p class="MsoNormal">Am 15.12.2023 um 08:28 schrieb Huesmann, Michaela via QGIS-User:<u></u><u></u></p>
</div>
<blockquote style="margin-top:5pt;margin-bottom:5pt">
<p class="MsoNormal">Hello QGIS Users,<u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal">I need to access an Oracle Database in QGIS. The scheme I need to connect to has plenty of tables and Views and it seems that all data is loaded in the background even before I was able to select the few tables I will really need. This
lakes a lot of time. <u></u><u></u></p>
<p class="MsoNormal">Is this a normal behaviour or can I ajust something in Database options? Thanks for your help!<u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal">Best regards, <u></u><u></u></p>
<p class="MsoNormal">Michaela<u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal"><span><u></u> <u></u></span></p>
<table border="0" cellspacing="0" cellpadding="0" width="556" style="width:417pt;border-collapse:collapse">
<tbody>
<tr>
<td width="260" style="width:195pt;padding:0cm">
<p class="MsoNormal"><span><a href="http://www.steinfurt.de" target="_blank"><span style="text-decoration:none"><img border="0" width="228" height="98" style="width: 2.375in; height: 1.0208in;" id="m_-4844318988259702093_x0000_i1026" src="cid:ii_18c8634891b5b006a2" alt="Kreisstadt Steinfurt"></span></a><br>
<br>
- </span><span style="font-size:10pt;font-family:Arial,sans-serif;color:rgb(125,125,125)">48565</span><span> </span><span style="font-size:10pt;font-family:Arial,sans-serif;color:rgb(125,125,125)">Steinfurt</span><span><br>
</span><span style="font-size:10pt;font-family:Arial,sans-serif;color:rgb(125,125,125)"><a href="http://www.steinfurt.de" target="_blank"><span style="color:rgb(125,125,125);text-decoration:none">www.steinfurt.de</span></a></span><span><u></u><u></u></span></p>
</td>
<td width="295" valign="top" style="width:221.25pt;padding:0cm">
<p class="MsoNormal"><span style="font-size:10pt;font-family:Arial,sans-serif"><br>
<br>
Mit freundlichen Grüßen</span><span style="font-family:Arial,sans-serif"><br>
</span><span style="font-size:10pt;font-family:Arial,sans-serif">im Auftrag<br>
</span><b><span style="font-size:13.5pt;font-family:Arial,sans-serif;color:black">Michaela Huesmann</span></b><span style="font-size:5pt;font-family:Arial,sans-serif"> </span><span style="font-size:10.5pt;font-family:Arial,sans-serif;color:black"><br>
</span><i><span style="font-size:10pt;font-family:Arial,sans-serif;color:black">IT</span></i><span style="font-size:10.5pt;font-family:Arial,sans-serif;color:black"><br>
</span><span style="font-size:10pt;font-family:Arial,sans-serif;color:black">Fachdienst Tiefbau</span><span style="font-size:10.5pt;font-family:Arial,sans-serif;color:black"><br>
</span><span style="font-size:5pt;font-family:Arial,sans-serif"> </span><span style="font-family:Arial,sans-serif"><br>
</span><span style="font-size:10pt;font-family:Arial,sans-serif;color:black">Tel.: +49 2552 925 219</span><span><br>
</span><span style="font-size:10pt;font-family:Arial,sans-serif;color:black">Fax:</span><span style="font-size:7.5pt;font-family:Arial,sans-serif;color:black">
</span><span style="font-size:9pt;font-family:Arial,sans-serif;color:black"><br>
</span><span style="font-size:10pt;font-family:Arial,sans-serif;color:black">E-Mail:
<a href="mailto:michaela.huesmann@Stadt-Steinfurt.de" title="Click to send email to Huesmann, Michaela" target="_blank">
<span style="color:black;text-decoration:none">michaela.huesmann@Stadt-Steinfurt.de</span></a></span><span><u></u><u></u></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:Arial,sans-serif;color:rgb(125,125,125)"><br>
Bitte denken Sie an die Umwelt, bevor Sie diese E-Mail ausdrucken.<br>
</span><span><br>
<br>
<br>
<u></u><u></u></span></p>
<pre>_______________________________________________<u></u><u></u></pre>
<pre>QGIS-User mailing list<u></u><u></u></pre>
<pre><a href="mailto:QGIS-User@lists.osgeo.org" target="_blank">QGIS-User@lists.osgeo.org</a><u></u><u></u></pre>
<pre>List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><u></u><u></u></pre>
<pre>Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-us" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-us</a><u></u><u></u></pre>
</blockquote>
</div>
</div>
_______________________________________________<br>
QGIS-User mailing list<br>
<a href="mailto:QGIS-User@lists.osgeo.org" target="_blank">QGIS-User@lists.osgeo.org</a><br>
List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
</div></blockquote></div>