Oracle Upgrade

Step 01> If you have Oracle SQL Developer installed, double click the OracleCapabilities.sql file to launch it, and run the script from within this application, otherwise, the database can updated with the command line interface sqlplus

Step 02> Open a Command window; click Start and Run.

Step 03> Enter cmd and press OK.

Step 04> Change to the install directory, and enter the command sqlplus then login as a DBA and run the OracleCapabilities.sql script with the command:


Step 05> The resultant output from running this command is a list outlining all maps and their assigned capabilities (queries, reports, etc), as configured in your existing Dekho 2.x configuration. This output should be saved to file (cut & paste if needs be) to be used as a guide to re-establish these capabilities once the maps have been reconfigured for Dekho 3.0.

In the same fashion as above, the SQL script OracleRoles.sql should be run, this outlines which roles have access to each map. Save this output for later use, this will be utilised once the maps have been reconfigured for Dekho v3.0.

With the two reports output from your existing Dekho configuration database, it can now be upgraded to version 3.0. This process will remove all maps from the database, allowing their reconfiguration for version 3.0.

Depending on your current version of Dekho 2.x, several upgrade scripts may need to be run before the final 3.0 upgrade script. The 3.0 upgrade scripts must be run on the most up to date version of Dekho 2.x, which is 2.2.6, so if you are currently on 2.2.4 for example, three scripts would be required for example




Each of the above scripts can be run through Oracle SQL Developer or the command line interface sqlplus.

Once all scripts have been run, your database has been prepared for Dekho v3.0.

The Dekho Administration Guide contains details on how to recreate your Dekho 2.x based maps in Dekho 3.

In Dekho 2.x Map Queries uniquely identified map layers by the name of the feature class in which their data was stored, in Dekho 3.x this unique identifier is the fully qualified layer name itself, i.e:




Geometry Service