Re: ORA-1300

Robbert van der Hoorn wrote:
> "ennio" <ennioj_at_libero.it> schreef in bericht
> news:1160037674.343959.271040_at_b28g2000cwb.googlegroups.com...
> > Hi.....
> > I occourred in this Error:
> > SELECT SDO_GEOM.SDO_Distance(A.geom,B.geom,0.00005)
> > FROM montane A,montane B
> > ORA-1300: dimension number out of range
> > The number of dimension are two and the table also are at two
> > dimension,,,,
> > Also it work when i restricted the distance to 0,,,,,
> > What the problem?
> >
>
> Think you mean ORA-13000. Please be precise...
> Looks like you're running into an invalid geometry in this query (maybe a
> singleton?). Try the same query with a where clause, limiting the number of
> geometries used, this finding the corrupt geometry
>
> Or try this:
>
> SELECT SDO_GEOM.SDO_Distance(A.geom,2, B.geom, 2, 0.00005)
> FROM montane A,montane B
>
> (explicitly defining the dimension numbers)
>
> or try with a somewhat higher tolerance (0.05)
>
> AND in all cases use where A.id <> B.id (for their distance will be 0)
>
> If all fails: flush your SGA, and rebuild your geometric index on montane.
> Distance calculations are based on the index. Like I stated before: spatial
> is somewhat instable...
>
> What platform (OS, DB version) are you on? Especially Spatial is behaving
> very different on different platforms, different versions
>
> Robbert van der Hoorn
> OSA it BV
> The Netherlands

Hi Robbert.......
windows XP Oracle 10g 2. Xe.....
If distance is 0 it works
What means SGA? Received on Thu Oct 05 2006 - 04:17:36 CDT