The dropRepositoryAndUserObjects script drops the Oracle Data Miner repository and related objects in the users' schemas.
If any sessions that have the ODMRUSER role are currently running, then the session object locks block the upgrade. You can use the session_disconnect parameter to disconnect any active sessions, thus enabling the upgrade process to proceed.
Syntax:
dropRepositoryAndUserObjects.sql session_disconnect
Parameters:
session_disconnect can have one of the following values:
R — Report active sessions. Do not disconnect them.
D — Disconnect active sessions. Do not report them.
DR or RD — Disconnect and report active sessions.
Example:
This example drops the ODMRSYS, schema and related objects in the Oracle Data Miner users' schemas, disconnecting and reporting any active ODMRUSER sessions.
@dropRepositoryAndUserObjects DR