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

Davo,

As Christof mentionned, people have been successfully indexing much larger datasets without problems.

 > ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine  > ORA-06512: at line 1

There should be further information with that error message that could help isolate the problem. Did you see any ?

Albert

-- 
Albert Godfrind                   Oracle Data Server Division
Oracle Corporation                Location and Geospatial Services
Village d’Entreprises Green Side  Email:  albert.godfrind_at_oracle.com
Bat N°7 - Entrée 2                Phone:  +(33) (0) 4 89 08 88 91
400 av. Roumanille - BP 309       Mobile: +(33) (0) 6 09 97 27 23
06906 Sophia-Antipolis            FAX:    +(33) (0) 4 89 08 88 44
France                            http://www.oracle.com

davo wrote:


> 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