Of course when you're running the current version of Oracle you _still_ have
to "migrate to current". This solved the problem:
EXECUTE SDO_MIGRATE.TO_CURRENT('TABLENAME','GEOM_COLUMN');"Chris Condit"
<condit_at_sdsc.edu> wrote in message news:e81jb5$6iv$1_at_news1.ucsd.edu...
> I'm getting a very mischievous error when querying Oracle spatial (10g
> release 2). The table was created by loading from a shapefile with
> polygons using Oracle's shp2sdo.
>
>
>
> I want to run the following aggregate query:
>
> SELECT SDO_AGGR_UNION(MDSYS.SDOAGGRTYPE(SHAPE,0.05)) FROM BENHAB
>
> Which of course give me the following informative error:
>
> ORA-13000: dimension number is out of range
>
> ORA-06512: at "MDSYS.MD", line 1723
>
> ORA-06512: at "MDSYS.MDERR", line 8
>
> ORA-06512: at "MDSYS.SDO_CONSTRUCT_DIM_ARRAY", line 27
>
> ORA-06512: at "MDSYS.AGGRUNION", line 20
>
>
> Cause: The specified dimension is either smaller than 1 or greater than
> the number of dimensions encoded in the HHCODE.
>
> In fact all of the arrgegate queries yield the same result. The data is
> two dimensional. I'm not clear on why the dimension is not compatible
> with the HHCODE, nor am I clear how to specify the dimension or change the
> HHCODE.
>
> Please help...
>
>
>
Received on Thu Jun 29 2006 - 19:08:23 CDT
