Insert into TEST_OMER(MI_PRINX,GEOLOC)
Select k.MI_PRINX,SDO_CS.MAKE_2D(k.GEOLOC) as GEOLOC  from
(Select (rownum +10) as MI_PRINX,sdo_geometry(t.ogc_geometry.sdo_gtype,null,null,t.ogc_geometry.sdo_elem_info,t.ogc_geometry.sdo_ordinates) as GEOLOC
from CABS.S_ANAHATLAR@sebekedblink t) k