oracle数据库升级空间数据库命令

#首先用dba打开数据库连接

system/manager as sysdba

 

@%ORACLE_HOME%\md\admin\sdoupggeom.sql

输入@完整路径执行。例如@D:\app\orcl\md\admin\sdoupggeom.sql）
2.1.3 添加4490坐标系
数
insert into sdo_ellipsoids values(7052,'CGCS2000',6378137,9001,298.257222101,6356752.2982159695,'BP','EPSG','FALSE',null);
commit;
insert into mdsys.sdo_datums values(6672,'D_China_2000','GEODETIC',7052,8901,'BP','EPSG',null,null,null,null,null,null,null,'FALSE',null);
commit;
INSERT INTO SDO_COORD_REF_SYSTEM (
SRID,COORD_REF_SYS_NAME,COORD_REF_SYS_KIND,COORD_SYS_ID,DATUM_ID,GEOG_CRS_DATUM_ID,SOURCE_GEOG_SRID,PROJECTION_CONV_ID,CMPD_HORIZ_SRID,CMPD_VERT_SRID,INFORMATION_SOURCE,DATA_SOURCE,IS_LEGACY,LEGACY_CODE,LEGACY_WKTEXT,LEGACY_CS_BOUNDS,IS_VALID,SUPPORTS_SDO_GEOMETRY)
VALUES (4490,'China Geodetic Coordinate System 2000','GEOGRAPHIC2D',
6422,6672,6672,NULL,NULL,NULL,NULL,NULL,'EPSG','FALSE',NULL,NULL,NULL,'TRUE','TRUE');
commit;