重装 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');

ps:安装ORDIM时，会创建MDSYS用户

--赋权：

grant the required privileges to MDSYS byrunning:

 SQL> connect / as sysdba

   SQL> @?/md/admin/mdprivs.sql

--安装：

   SQL> @?/md/admin/mdinst.sql