Mapinfo Easyloader 轉入Oracle spatial
刪除table spatial index
INSERT INTO USER_SDO_GEOM_METADATA
VALUES (
'TOWN_97_OK',
'GEOLOC',
MDSYS.SDO_DIM_ARRAY(
MDSYS.SDO_DIM_ELEMENT('X', -7998349.27594, 8498349.27594, .000000003),
MDSYS.SDO_DIM_ELEMENT('Y', -10001001.0314, 10001001.0314, 4.5000E-09)
),
NULL --SRID
);
DROP INDEX COUN_POLY_97_OK_IDX;
CREATE INDEX COUN_POLY_97_OK_IDX
ON "GISSEC"."TOWN_97_OK"(GEOLOC)
INDEXTYPE IS MDSYS.SPATIAL_INDEX;
