Need help doing a dissolve in Oracle
Posted on 2011-02-22
I am trying to dissolve a large number of polygons. In ArcGIS the operation simply was not practical so I am trying to do it in Oracle. For my initial test I am trying this:
FROM ADDRESS_EXTRACT_FC_BUFFER_RI c
where c.objectid < 101
group by TRANSTECH,MAXADDOWN,MAXADUP,HOCONAME,HOCONUM,SHAPE;
But I am getting the following error:
ORA-22901: cannot compare VARRAY or LOB attributes of an object type
22901. 00000 - "cannot compare nested table or VARRAY or LOB attributes of an object type"
*Cause: Comparison of nested table or VARRAY or LOB attributes of an
object type was attempted in the absence of a MAP or ORDER
*Action: define a MAP or ORDER method for the object type.
Error at Line: 12 Column: 54
If I do the aggregate function on the shape column only it works successfully. I tried adding an ordered hint but no sucess either.
Any Ideas will be greatly appreciated.