The upgradeRepoFromORtoBinary
script migrates the ODMRSYS
workflow data from object-relational XML storage to binary XML storage. The upgraded ODMRSYS
tablespace is an Oracle Automatic Segment Space Management (ASSM) tablespace.
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:
@upgradeRepoFromORtoBinary.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 upgrades ODMRSYS
from object-relational XML storage to binary XML storage. The upgraded tablespace is ASSM-based. If any ODMRUSER
sessions are active, they are disconnected and reported.
@upgradeRepoFromORtoBinary DR
Parent topic: Migrating the Repository