空间数据库相关步骤‏

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;