Merge region boundary by using sdo_aggr_union
645793Jan 6 2012 — edited Jan 16 2012Hi,
I have geometry data in Oracle Enterprise 11gR2 which contain electoral division (belongs to State) boundaries information. I want to create a new table with State boundary information. So I run the following DML:
create table australia_state
as
select state, sdo_aggr_union(sdoaggrtype(geometry,0.05)) geometry from
com20111216_elb_region group by state;
But, it gave the following error message after running for a couple of hours:
Error report:
SQL Error: ORA-22165: given index [1048576] must be in the range of [0] to [1048575]
22165. 00000 - "given index [%s] must be in the range of [%s] to [%s]"
*Cause: Given index is not in the required range.
*Action: Ensure that the given index is in the required range.
My question is:
1, How can i solve this "index" issue?
2, Why it takes so long? The original table only has 150 rows and my machine is 2 cores CPU with 4G RAM;
Thanks a lot.