NO ODM IN DBA_REGISTRY AND NO DMSYS Schema In 11G And Above And How To Remove IT

(Doc ID 1497250.1)

Last updated on SEPTEMBER 01, 2017

Applies to:

Oracle Data Mining - Version and later
Information in this document applies to any platform.


You are planning to upgrade your databases from 11.2.0.x to
As per the pre-req checks, the DMSYS schema has to be removed prior to the upgrade as the ODM objects do not reside in a separate schema.

The note  was written for users who upgrade from 10.2.x  to 11g. It is also applicable to 10.2 users who need to remove Data Mining product from the database:



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