I have a data set with mixed SDO_GTYPE 2007 and SDO_GTYPE 2003, however for the task I am working on only SDO_GTYPE 2003 is allowed for practical reasons.
I was able to extract the polygons in a querie from the multipolygons, however I don't know how to save the polygons in a new table and I couldn't find any helpful information on how to do it.
My code so far:
SELECT SDO_UTIL.EXTRACT_ALL(t1.GEOMETRY, 0) FROM table t1 WHERE t1.GEOMETRY.SDO_GTYPE = 2007; CREATE TABLE "TEST"."POLYGON" ( "GEOINVFL_N" VARCHAR2(16 CHAR), "GEOMETRY" "MDSYS"."SDO_GEOMETRY" )
I am working in Oracle 12.1