A Installation, Compatibility, and Upgrade

If you are upgrading to Oracle Database 11g, Oracle Spatial is automatically upgraded as part of the operation. For information about the upgrade procedure, see Oracle Database Upgrade Guide.

If you need to downgrade Spatial to the previous Oracle Database release, follow the instructions for downgrading a database back to the previous Oracle Database release in Oracle Database Upgrade Guide.

If you use Oracle Spatial GeoRaster, see Section A.1.

A.1 Ensuring That GeoRaster Works Properly After an Upgrade

If you are upgrading to Oracle Database 11g and if you use the GeoRaster feature of Oracle Spatial, Oracle XML DB Repository must be installed. Before you use GeoRaster in the upgraded instance, ensure that both of these requirements are met, and if necessary reload the GeoRaster PL/SQL packages. Follow these steps:

Check to see if Oracle XML DB Repository is installed; and if it is not installed, install it.

For information about installing and uninstalling Oracle XML DB Repository, see Oracle XML DB Developer's Guide.
Go to the $ORACLE_HOME/md/admin directory.
Connect to the database as SYS AS SYSDBA.

Enter the following SQL statements:

ALTER SESSION SET CURRENT_SCHEMA=MDSYS;
@prvtgrs.plb
@sdogrxml.sql