How to Uninstall XDK/XSU from non SYS schema without Corrupting XDK/XSU in SYS schema (Doc ID 377546.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle XML Developers Kit - Version 9.2 and later
Information in this document applies to any platform.
***Checked for relevance on 5th Oct 2015***

Goal

The purpose is to de-install XDK/XSU from non SYS schema without corrupting XDK/XSU in SYS schema. i.e say your database has two versions of XDK one in SYS and other in non-SYS schema. The version in SYS schema is correct / intact and the version in non-SYS schema is not. So you have to only drop XDK/XSU from non-SYS schema without corrupting XDK/XSU in SYS schema or registry

TIP: Synonym's should be pointing to SYS, at the minimum the pl/sql wrapper synonym's. If the synonyms for both XDK Java classes and pl/sql wrappers are pointing to Non-SYS schema then the best option is de-install all versions of XDK and cleanly install in SYS by following <Note 317176.1>

 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms