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

From: davo <daven112003_at_yahoo.com.au>
Date: 26 Mar 2003 00:22:18 -0800
Message-ID: <6272daec.0303260022.32fd0577@posting.google.com>

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 - 02:22:18 CST