1.创建一个空间表
比如
DROP TABLE MAP;
CREATE TABLE MAP (
GID NUMBER(38)
PRIMARY KEY,
NAME VARCHAR2(10),
GEOM MDSYS.SDO_GEOMETRY);
2.在USER_SDO_GEOM_METADATA表中插入空间字段的相关信息
DELETE FROM USER_SDO_GEOM_METADATA
WHERE TABLE_NAME = 'MAP' AND COLUMN_NAME = 'GEOM' ;
INSERT INTO USER_SDO_GEOM_METADATA (TABLE_NAME, COLUMN_NAME, DIMINFO, SRID)
VALUES ('MAP', 'GEOM',
MDSYS.SDO_DIM_ARRAY
(MDSYS.SDO_DIM_ELEMENT('X', 84.708038330, 131.212371826, 0.000000050),
MDSYS.SDO_DIM_ELEMENT('Y', 21.173788071, 53.004581451, 0.000000050)
),
8307);
3.建立索引
CREATE Index MAP_idx ON MAP(GEOM) INDEXTYPE is MDSYS.SPATIAL_INDEX;