<HTML><HEAD><TITLE>RE Error loading a big oracle spatial layer</TITLE>
<META http-equiv=Content-Type content="text/html; charset=unicode">
<META content="MSHTML 6.00.6000.17023" name=GENERATOR></HEAD>
<BODY>
<DIV id=idOWAReplyText80956>
<DIV><FONT face="Times New Roman" color=#000000 size=3>Hello, Wolfgang:</FONT></DIV>
<DIV> </DIV>
<DIV>The structure of those geometries is not valid in my database (assuming I printed it correctly in the log file). It's strange because Oracle generally prevents illegal geometries from being inserted. I hope the SDO_GEOMETRY format has not changed in recent Oracle Spatial versions.</DIV>
<DIV> </DIV>
<DIV>How were those geometries inserted? Using SQL directly? Perhaps those geometries were inserted before creating the spatial index in that table? There is a suspicious detail: 31468 is not the right SRID value in your database. The German EPSG:31468 corresponds to Oracle Spatial SRID 82032.</DIV>
<DIV> </DIV>
<DIV>Please try this SQL in your database and tell me the result. Does it return TRUE, FALSE or a number?</DIV>
<DIV> </DIV>
<DIV>select sdo_geom.validate_geometry_with_context(sdo_geometry(3005, 31468, NULL, sdo_elem_info_array(1.0 , 2005.0 , 1.0 , 1.0 , 2.0 , 2.0), sdo_ordinate_array(4478106.584 , 5345524.3355 , 0.0 , 4478103.55781412 , 5345520.13869913 , 0.0 , 4478094.627 , 5345517.0485 , 0.0 , 4478088.31210806 , 5345521.30429374 , 0.0 , 4478087.661 , 5345528.8915 , 0.0 , 4478093.20816592 , 5345537.22495391 , 0.0 , 4478103.219 , 5345537.2515 , 0.0 , 4478107.61580098 , 5345529.07024585 , 0.0 , 4478107.585 , 5345528.688 , 0.0 , 4478107.28586386 , 5345526.46542887 , 0.0 , 4478106.584 , 5345524.3355 , 0.0)), 0.0005) from dual</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>Regards,</DIV>
<DIV><FONT face="Courier New" size=2><FONT face="Times New Roman" size=3></FONT></FONT> </DIV>
<DIV><FONT face="Courier New" size=2><FONT face="Times New Roman" size=3>Juan Lucas Domínguez Rubio<BR></FONT>---</FONT></DIV></DIV>
<DIV id=idSignature465>
<DIV><FONT face="Courier New" size=2><FONT face="Courier New" size=2><FONT face="Courier New" size=2>Prodevelop SL, Valencia (España)</FONT></DIV>
<DIV>
<DIV><FONT face="Courier New" size=2>Tlf.: 96.351.06.12 -- Fax: 96.351.09.68<BR></FONT><A href="http://www.prodevelop.es/"><FONT face="Courier New" size=2>http://www.prodevelop.es</FONT></A><BR><FONT face="Courier New" size=2>---</FONT></DIV></FONT></DIV></FONT></DIV>
<DIV><BR>
<HR>
<FONT face=Tahoma size=2><B>De:</B> Wolfgang Qual [mailto:wolfgang.qual@muenchen.de]<BR><B>Enviado el:</B> jue 22/04/2010 13:59<BR><B>Para:</B> Juan Lucas Dominguez Rubio; Users and Developers mailing list<BR><B>Asunto:</B> RE Error loading a big oracle spatial layer<BR></FONT><BR></DIV>
<DIV>
<P><FONT size=2>Dear Juan Lucas,<BR>please find enclosed the requested logfile. Hope that helps to find the<BR>bug... ;)<BR><BR>Best,<BR>Wolfgang<BR><BR>--<BR>Wolfgang Qual<BR><BR>Landeshauptstadt München<BR>Referat für Gesundheit und Umwelt<BR>Umweltschutz, Umweltvorsorge<BR>RGU-UW 11<BR>Team Klimaschutz, Energie<BR><BR>Bayerstraße 28a<BR>80335 München<BR><BR>Telefon: +49 - 89 - 233 - 4 77 17<BR>Telefax: +49 - 89 - 233 - 4 77 05<BR>E-Mail: wolfgang.qual@muenchen.de<BR>Internet: <A href="http://www.muenchen.de/rgu">http://www.muenchen.de/rgu</A><BR><BR>Bitte beachten Sie die Hinweise zur elektronischen<BR>Kommunikation mit der Landeshauptstadt München:<BR><A href="http://www.muenchen.de/ekomm">http://www.muenchen.de/ekomm</A><BR><BR></FONT></P></DIV></BODY></HTML>