<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>Hi Rémy,<br><br>If you inserted table_name and column_name in uppercase into the user_sdo_geom_metadata it should works. You should be able to run "ogrinfo oci:user/pwd@db" and see that after the ORA-04043 error the view will be listed as a layer anyway. Try also "ogrinfo oci:user/pwd@db <view name>". And if you want to debug it you can add "--debug on" at the end of the command.<br><br>Regards,<br><br>Ivan<br><br><div>> From: rgourrat@ag-carto.fr<br>> To: gdal-dev@lists.osgeo.org<br>> Date: Mon, 31 Mar 2014 20:03:20 +0000<br>> Subject: [gdal-dev] ogrinfo 1.10 with oracle view is failing<br>> <br>> Hi,<br>> <br>> I do an ogrinfo on oracle view.<br>> <br>> Ogrinfo return ora-04043 object don't exist<br>> <br>> i do the same command on the native table with success.<br>> <br>> So i check the metadata in user_sdo_geom_metadata, it's same metadata for the view and the table.<br>> <br>> I recompile the view to have exactly same fields, same tablespace... in the view that the table (create myview as select * from mytable)<br>> <br>> But it's always the same issue :<br>> Ora-04043...<br>> <br>> I use :<br>> Ogrinfo 1.10 (from Qgis 2.0.1)<br>> Oracle instant client 12 64bits<br>> Oracle database 10g2<br>> <br>> In sqldevelopper with the same user used with ogrinfo i can :<br>> - describe the view<br>> - select<br>> -...<br>> <br>> Thanks for your advice<br>> <br>> Remy<br>> _______________________________________________<br>> gdal-dev mailing list<br>> gdal-dev@lists.osgeo.org<br>> http://lists.osgeo.org/mailman/listinfo/gdal-dev<br></div> </div></body>
</html>