Hello,
I try to make a point materialized (point) view from a polygon table. First I make a selection on the geometry to make it a point I use SDO_GEOM.SDO_CENTROID on the geometry so I get an extra geometry column 'GEOMETRIE2' which has the centroid of a polygon.
[ATTACH=CONFIG]28676[/ATTACH]
After the selection I do an insert on USER_SDO_GEOM_METADATA:
insert into USER_SDO_GEOM_METADATA (
TABLE_NAME,
COLUMN_NAME,
DIMINFO,
SRID)
values (
'TABLETEST',
'GEOMETRIE2',
MSDYS.SDO_DIM_ARRAY (
MDSYS.SDO_DIM_ELEMENT('X', 70000, 180000, 0.01),
MDSYS.SDO_DIM_ELEMENT('Y', 480000, 580000, 0.01)),
'');
I then register the table by sdelayer:
sdelayer �??o register �??l TABLETEST,GEOMETRIE2 �??e p -t SDO_GEOMETRY �??C SEQ_ID,USER �??k SDO_GEOMETRY �??P HIGH �??x 0,0,5000,0.02 �??G 28992
However this will result in the following error:
Error: Abstract Data Types not supported (-320).
Error: Cannot Create Layer.
Any ideas?