重装 11G(11.2.0.4) SDO组件
目录
Spatial 组件重建
依赖关系，先要有 select comp_id,version,status fromdba_registry where comp_id in (‘JAVAVM’,’ORDIM’,’XDB’);这三个组件有效
1 Spatial 组件卸载
1.1 drop Spatical 用户：MDSYS
SQL>drop user MDSYS cascade;
SQL>drop user mddata cascade;
SQL>drop user spatial_csw_admin_usr cascade;
SQL>drop user spatial_wfs_admin_usr cascade;
2 Oracle 11g 安装Spatial
在Oracle 10g/11g 中安装Spatial 组件，必须先保证如下三个组件已经存在：
select comp_id,version,status fromdba_registry where comp_id in
(‘JAVAVM’,’ORDIM’,’XDB’);
(‘JAVAVM’,’ORDIM’,’XDB’);
ps:安装ORDIM时，会创建MDSYS用户
–赋权：
grant the required privileges to MDSYS byrunning:
SQL> connect / as sysdba
SQL> @?/md/admin/mdprivs.sql
–安装：
SQL> @?/md/admin/mdinst.sql
转载自：https://blog.csdn.net/u013225189/article/details/77351703
