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
We did {insert item} and it failed!
1 day ago
No comments:
Post a Comment