<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta name="Generator" content="Microsoft Word 12 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 70.85pt 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="FR-BE" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="color:#1F497D">Rémy,<o:p></o:p></span></p>
<p class="MsoNormal" style="text-indent:35.4pt"><span style="color:#1F497D">One way to overcome delay is to add view name (or table name) in the command line.
<o:p></o:p></span></p>
<p class="MsoNormal" style="text-indent:35.4pt"><span style="color:#1F497D">Doing so will prevent you for scanning tables in the DB.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal" style="text-indent:35.4pt"><span style="color:#1F497D">ogrinfo OCI:USR/PWD@INSTANCE:</span><span lang="EN-US" style="font-size:10.0pt">V_AGRI_EXPLOITATION<o:p></o:p></span></p>
<p class="MsoNormal" style="text-indent:35.4pt"><span lang="EN-US" style="font-size:10.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Nicolas<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="FR" style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">De :</span></b><span lang="FR" style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> gdal-dev-bounces@lists.osgeo.org [mailto:gdal-dev-bounces@lists.osgeo.org]
<b>De la part de</b> Rémy GOURRAT<br>
<b>Envoyé :</b> jeudi 3 avril 2014 12:42<br>
<b>À :</b> gdal-dev@lists.osgeo.org<br>
<b>Objet :</b> [gdal-dev] [gdal 1.10] ogr2ogr ora-04043 object does not exist with spatial views in another schema of the connected user<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">Hi,<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">my Oracle user connected had the “SELECT ANY TABLE” privilege so when I execute ogr2ogr to generate shp,<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">before to write the shape, ogr2ogr try to describe spatial View and table in each schema.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">It’s very long to generate a small shape because for each spatial view of another schema of the connected user<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">I have this message “ERROR 1: ORA-04043: object <the schema name>.<the spatial view name> does not exist<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"> in OCIDescribeAny”,
</span><span lang="EN-US">we have a lot of spatial views in different schemas…<span style="color:#1F497D"><o:p></o:p></span></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">but </span><span lang="EN-US">It seems that I have a issue with the views of another schemas,
<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">not tables and <u>not views of the current schema (connected user)</u>.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Does I forget a privilege on my Oracle User ? a describe privilege that I don’t know ?<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"> <o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Is there a switch to force ogr2ogr to use USER_SDO_GEOM_METADATA ?<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">When i drop the <span style="color:#1F497D">
“SELECT ANY TABLE” to the Oracle User, <o:p></o:p></span></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">I have not this message and it’s fast again.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">Debug On, first I see that ogr2ogr list every table and every view with this request, (I put interline to optimize lisibility)<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt">OCI: Userid=****, Password=****, Database=****<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt">OCI: Prepare(ALTER SESSION SET NLS_DATE_FORMAT='YYYY/MM/DD' NLS_TIME_FORMAT='HH24:MI:SS' NLS_TIME_TZ_FORMAT='HH24:MI:SS TZHTZM' NLS_TIMESTAMP_FORMAT='YYYY/MM/DD HH24:MI:SS'
NLS_TIMESTAMP_TZ_FORMAT='YYYY/MM/DD HH24:MI:SS TZHTZM')<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt">OCI: Prepare(SELECT TABLE_NAME, OWNER FROM
<b>ALL_SDO_GEOM_METADATA</b>)<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt">ERROR 1: ORA-04043: object ORA_URBA.V_AGRI_EXPLOITATION does not exist in OCIDescribeAny<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt">OCI: Prepare(SELECT COUNT(*) FROM ALL_SDO_GEOM_METADATA u, TABLE(u.diminfo) t WHERE u.table_name = 'V_AGRI_EXPLOITATION' AND u.column_name = 'GEOMETRY')<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt">OCI: Prepare(SELECT SRID FROM ALL_SDO_GEOM_METADATA WHERE TABLE_NAME = UPPER('V_AGRI_EXPLOITATION') AND COLUMN_NAME = UPPER('GEOMETRY') AND OWNER = 'ORA_URBA')<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt">ERROR 1: ORA-04043: object ORA_URBA.V_AGRI_EXPLOITATION_EXPLOITANT does not exist in OCIDescribeAny<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt">OCI: Prepare(SELECT COUNT(*) FROM ALL_SDO_GEOM_METADATA u, TABLE(u.diminfo) t WHERE u.table_name = 'V_AGRI_EXPLOITATION_EXPLOITANT' AND u.column_name = 'GEOMETRY')<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt">OCI: Prepare(SELECT SRID FROM ALL_SDO_GEOM_METADATA WHERE TABLE_NAME = UPPER('V_AGRI_EXPLOITATION_EXPLOITANT') AND COLUMN_NAME = UPPER('GEOMETRY') AND OWNER = 'ORA_URBA')<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt">ERROR 1: ORA-04043: object ORA_URBA.V_AGRI_EXPLOITATION_PERIMETRE does not exist in OCIDescribeAny<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt">OCI: Prepare(SELECT COUNT(*) FROM ALL_SDO_GEOM_METADATA u, TABLE(u.diminfo) t WHERE u.table_name = 'V_AGRI_EXPLOITATION_PERIMETRE' AND u.column_name = 'GEOMETRY')<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt">OCI: Prepare(SELECT SRID FROM ALL_SDO_GEOM_METADATA WHERE TABLE_NAME = UPPER('V_AGRI_EXPLOITATION_PERIMETRE') AND COLUMN_NAME = UPPER('GEOMETRY') AND OWNER = 'ORA_URBA')<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt">ERROR 1: ORA-04043: object ORA_URBA.V_AGRI_PAC_ILOT does not exist in OCIDescribeAny<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt">Thanks for your help<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Rémy Gourrat<o:p></o:p></span></p>
</div>
</body>
</html>