A third party software (ArcGIS) creates spatial tables with the following DIMINFO for the spatial metadata
((, -5120900, -4906151.6353, 0.001), (, -9998100, -9783351.6353, 0.001), (DEFAULT_3D, -100000, 114748.3647, 0.001), (, , , ))
I need to be able to insert the same metadata that was inserted by ArcGIS in order to create loading tables for ETL but I cant seem to create the 4th dimension with null or zero tolerance.
when I try this:
Insert into user_sdo_geom_metadata
(TABLE_NAME, COLUMN_NAME, DIMINFO, SRID)
Values
('LINE3', 'SHAPE',
MDSYS.SDO_DIM_ARRAY(
MDSYS.SDO_DIM_ELEMENT(NULL, -5120900, -4906151.6353, 0.001),
MDSYS.SDO_DIM_ELEMENT(NULL, -9998100, -9783351.6353, 0.001),
MDSYS.SDO_DIM_ELEMENT('DEFAULT_3D', -100000, 114748.3647, 0.001),
MDSYS.SDO_DIM_ELEMENT(NULL,NULL,NULL,NULL) –- or zero for tolerance
), 26915);
I get
[Error] Execution (57: 13): ORA-13224: zero tolerance specified for layer in USER_SDO_GEOM_METADATA
ORA-06512: at "MDSYS.MD", line 1723
ORA-06512: at "MDSYS.MDERR", line 17
ORA-06512: at "MDSYS.SDO_GEOM_TRIG_INS1", line 78
ORA-04088: error during execution of trigger 'MDSYS.SDO_GEOM_TRIG_INS1'