The upgradeRepoWithNewTableSpace
script upgrades the specified tablespace from object-relational to binary XML storage and migrates the workflow data in ODMRSYS
to the newt tablespace. The new tablespace must be an Oracle Automatic Segment Space Management (Oracle 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:
upgradeRepoWithNewTableSpace.sql ASSMtablespace session_disconnect
Parameters:
ASSMtablespace
is the name of an ASSM tablespace.
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 migrates object-relational XML data in ODMRSYS
to the new ASSM tablespace, my_ASSM_space
, that uses binary XML storage. If any ODMRUSER
sessions are active, they are disconnected and reported.
@upgradeRepoWithNewTableSpace my_ASSM_space DR
See Also:
Parent topic: Migrating the Repository