Re: ORA-1300

ennio wrote:
> 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?

I Think i have find the problem ....
when i imported the data i have imported them whit 3 dimension and the USER_SDO_GEOM_METADATA has 2 dimension..... I try to cancel the data and import as new..... thanks.... Received on Thu Oct 05 2006 - 04:53:38 CDT