|Oracle8i Application Developer's Guide - XML
Release 3 (8.1.7)
Part Number A86030-01
Using XML Parser for Java, 19 of 22
I am deinstalling a version of XML Parser and installing a newer version. How do I do that? I know that there is something like dropjava , but still there are other packages which are loaded into the schema. I want to clean out the earlier version and install the new version in a clean manner.
You'll need to write SQL to write SQLbased on the USER_OBJECTS table where:
from user_objects where
This will spew out a set of DROP JAVA CLASS command which you can capture in a file using SQL*Plus': SPOOL somefilenamecommand.
Then run that spool file as a SQL script and all the right classeswill be dropped.