Re: Problem indexing million row tables with oracle spatial 9i rel 2

I indexed a couple of milion rows without probelms.

Normally, the problem you encountered happens, when some objects are outside the index bounds as defined in the sdo_geom_metadata. maybe one point has the coordinates x=0 y=0 which is outside your index bounding box? or on the cocos island or somewhere you didnt expect.

Or one ore more geometries are broken. That can be checked with validate_geometry. however, it would be hard to get a point geometry wrong.

you also can try to use the other index type (fixed type or r-tree).

hth
christof.

davo schrieb:

> Hi folks,
>
> I'm trying to create a spatial index on a table with a column that
> contains 2 dimensional point data like so :-
>
> CREATE INDEX CPR_ADDRESS_SX
> ON TAB1(GEOLOC)
> INDEXTYPE IS MDSYS.SPATIAL_INDEX;
>
> If the table has about 250 000 rows it works fine.
>
> When I load 1 million rows, and try to index it I get the following
> error :-
>
> ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
> ORA-06512: at line 1
>
> no clues about anything. There is over a gig free in temp, the
> rollbacks and the index table spaces. I've tried it on 2 different
> instances. I've loaded different chunks of data, in case it was a data
> problem. I always hit the same limit.
>
> Any ideas anyone? Has anyone successfully indexed large spatial tables
> like this?
>
> TIA,
> davo
Received on Wed Mar 26 2003 - 08:19:52 CST