Oracle - Explain how to install Oracle Spatial posted by
Babu Kunwar
Explain how to install Oracle Spatial
Oracle Spatial is designed to make spatial data management easier and more
natural to users of location-enabled applications and geographic information
system (GIS) applications. When spatial data is stored in an Oracle database,
it can be easily manipulated, retrieved, and related to all other data stored
in the database.
To be able to do a successful spatial 10g installation you need to have the
following products already installed:
To verify the above installed features please execute the query:
SQL> select comp_id, version, status from dba_registry where comp_id in
('JAVAVM','ORDIM','XDB');
Check whether MDSYS user exists or not. If it does not exist the create user as:
SQL> create user MDSYS identified by xxxxx default tablespace SYSAUX account
lock;
Grant permission as:
SQL> @?/md/admin/mdprivs.sql
Install spatial as:
SQL> connect / as sysdba
SQL> spool spatial_installation.lst
SQL> @?/md/admin/mdinst.sql
SQL> spool off
SQL> alter user MDSYS account lock;
|
