1,在user_sdo_geom_metadata表中插入或者修改需要修改表的名稱，表中的geometry字段名稱和srid。具體可參考該表的字段。
INSERT INTO USER_SDO_GEOM_METADATA (table_name,column_name,DimInfo,srid)
VALUES (UPPER(‘TB_REALTIME_FIREDISRECORD_T’), UPPER(‘COORDINATES’),
MDSYS.SDO_DIM_ARRAY(
MDSYS.SDO_DIM_ELEMENT(‘X’,114.877478378889,119.644269545556,0.005),
MDSYS.SDO_DIM_ELEMENT(‘Y’,29.395623565556,34.655112621111,0.005)
),
8307);
2，在修改字段的srid之前，需要删除該字段上得空間索引：
drop index TB_PG_TOWERINFO_STATIONMAP_SPX;
3，使用遊标周遊表中的字段，修改geometry字段的srid的值：
declare
geo sdo_geometry;
cursor pointer is
select T.STATIONMAP , T.TOWERID from DMSDKY.TB_PG_TOWERINFO t;
p pointer%rowtype;
begin
for p in pointer loop
geo := P.STATIONMAP;
if geo is not null then
if geo.sdo_srid is null then
geo.sdo_srid := 8307;
update DMSDKY.TB_PG_TOWERINFO t set T.STATIONMAP = geo where T.TOWERID = P.TOWERID;
COMMIT;
end if;
end if;
end loop;
end;
4，修改完之後再重新建立字段上得索引，注意如果字段中仍含有未修改的字段值，則會出現ora-13365錯誤
create index TB_PG_TOWERINFO_STATIONMAP_SPX on TB_PG_TOWERINFO t (T.STATIONMAP ) indextype is mdsys.spatial_index;
轉載自：https://blog.csdn.net/jxzz016590/article/details/38681431