Migrate the Data Miner Repository

There are several scripts that migrate the Repository. The correct script to use depends on the exact scenario:

Scenario Script Comments
Data Miner (any version) installed on Oracle Database11g Release 2 (11.2.0.1,11.2.0.2, 11.2.0.3) migrateodmr.sql

Data Miner 3.2.2 or earlier installed on Database11g Release 2 (11.2.0.4) and later, where the default ODMRSYS tablespace is not ASM based upgradeRepoWithNewTableSpace.sql
ASM tablespace required as input parameter. Used to migrate the workflow data from XML Object Storage to XML Binary Storage
Data Miner 3.2.2 installed on Oracle Database11g Release 2 (11.2.0.4) and later, where the default ODMRSYS tablespace is ASM based upgradeRepoFromORtoBinary.sql
Workflow data will be migrated from XML Object Storage to XML Binary Storage
Data Miner 4.0 installed on Oracle Database11g Release 2 (11.2.0.4) and later. migrateodmr.sql
For future releases where there is no conversion from Object Storage to Binary required.

If the migration fails, the database may be left in restricted mode. See Migration Failure to disable the restricted session.

You can also Migrate Using GUI.