空间数据库相关步骤‏

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;