Installing a newer versionAfter installing Orchem you will have a number of Orchem database objects created inside the Oracle server. These consist of tables, packages, indexes, types, sequences and a lot of Java classes. If you want to upgrade to a newer version of Orchem, first you should get rid of the existing Orchem database objects. This page gives some suggestions how you could do this.
Option 1 - drop/recreate entire Orchem schema and reinstallIf you installed Orchem into its own schema, you (or your DBA) can drop this schema and recreate it. It will then be empty, and you can commence installation from scratch with a blank schema, and after installation run the fingerprinting process.
Alternatively, you could create a new schema, install the latest version of Orchem in there, fingerprint the compounds and then switch your application to this new schema and afterwards drop the old one. This would give least interruption to any users.
Option 2 - drop/recreate database objects and reinstallThere is a script available in the disribution called cleanup.sql that will drop all the Orchem specific objects from the schema, leaving any other database objects intact. You can use this script if you did not install Orchem into its own schema (which excluded option 1), or if you don't want to drop the existing schema/account.
In case you have any other (non Orchem) Java classes loaded into the schema, check cleanup.sql beforehand. It lists the Java package prefixes of classes that are going to be dropped, double check that.
Running the script with Sql*Plus is straightforward:
$ sqlplus orchem/orchem@marx >> SQL*Plus: Release 220.127.116.11.0 - Production on Tue May 19 17:48:27 2009 >> Copyright (c) 1982, 2007, Oracle. All rights reserved. >> @cleanupAfter the cleanup has finished, you can commence installation and after installation run the fingerprinting.