Create oracle spatial table

//创建table
create table rtree_table(id Number(6,0),xy MDSYS.SDO_GEOMETRY,name
varchar(100));

//插入数据
INSERT INTO USER_SDO_GEOM_METADATA
VALUES (
'rtree_table',
'xy',
MDSYS.SDO_DIM_ARRAY(
MDSYS.SDO_DIM_ELEMENT('X', 0, 600, 0.01),
MDSYS.SDO_DIM_ELEMENT('Y', 0, 600, 0.01)
),
NULL
);

//创建index
create index rtree_index on rtree_table(xy) indextype is
MDSYS.SPATIAL_INDEX;