Monday, March 28, 2011

How to Deinstall Oracle Spatial Locator in 10g/11g manually

How to Deinstall Oracle Spatial Locator in 10g/11g manually
===========================================================

Solution
===========


note: [SPATIAL must not be installed before de-installing Locator]

SQL> connect / as sysdba
SQL> select comp_id, control, schema, version, status, comp_name from dba_registry where comp_id='SDO';


If the above query returns a result, you cannot de-install Locator because Locator is part of Spatial installation and without removing Spatial , Locator cannot be de-installed.

If the above query does not return a result, execute following steps to de-install Locator.

SQL>Conn / as sysdba
SQL>spool locator_remove.lst
SQL>@?/md/admin/mddinloc.sql
SQL> spool off

No comments: