Starting with SQL Developer 4.0, Oracle Data Miner migration scripts are available for specific upgrade paths.
Table 5-1 Oracle Data Miner Upgrade Scripts
| SQL Developer Version | Database Version | Script | Description |
|---|---|---|---|
|
Any version |
11.2.0.1 - 11.2.0.3 | migrateodmr.sql |
Upgrades ODMRSYS. |
| 3.2.2 or earlier | 11.2.0.4 and later, where the default ODMRSYS tablespace is not ASSM-based |
upgradeRepoWithNewTableSpace.sql |
ASSM tablespace required as input parameter. This will be used to migrate the workflow data from XML object storage to XML binary storage. |
|
3.2.2 or earlier |
11.2.0.4 and later, where the default |
upgradeRepoFromORtoBinary.sql |
Workflow data will be migrated from XML object storage to XML binary storage. |
|
4.0 and later |
11.2.0.4 and later | migratebinaryodmr.sql |
Relevant for future releases, when XML conversion from object storage to binary storage will no longer needed |
|
4.0 and later |
11.2.0.3 or earlier originally, and then the database was upgraded to 11.2.0.4 or later | upgradeRepoWithNewTableSpace.sql or upgradeRepoFromORtoBinary.sql |
Since the database can be upgraded independently of the Oracle Data Miner repository, this has to be taken into account. The choice of scripts will depend on whether ODMRSYS tablespace is ASSM or not. |
Parent topic: Migrating the Repository