Preparing your Oracle environment

Review all the information required to prepare your Oracle environment for data migration.

Note: If you are upgrading in sharded mode, the instructions described in this section must be followed for all the shards in all the colonies.
The following table provides instructions for preparing your oracle environment during data migration:
When upgrading from 9.3 When upgrading from 9.4 When upgrading from 9.5
No changes.
  1. DROP INDEX YFS_INVENTORY_ALERTS_I4;
  2. DROP INDEX INV_INVENTORY_ITEM_LOCK_I1;
  3. CREATE UNIQUE INDEX INV_INVENTORY_ITEM_LOCK_I1_94 ON INV_INVENTORY_ITEM_LOCK (INVENTORY_ITEM_KEY ASC, DEMAND_TYPE ASC);
  4. CREATE UNIQUE INDEX YFS_INVENTORY_ALERTS_I4_930 ON YFS_INVENTORY_ALERTS (INVENTORY_ITEM_KEY ASC, SHIP_NODE ASC, ALERT_TYPE ASC, ALERT_LEVEL ASC, DISTRIBUTION_RULE_ID ASC, ORGANIZATION_CODE ASC);
  1. DROP INDEX INV_INVENTORY_ITEM_LOCK_I1;
  2. CREATE UNIQUE INDEX INV_INVENTORY_ITEM_LOCK_I1_94 ON INV_INVENTORY_ITEM_LOCK (INVENTORY_ITEM_KEY ASC, DEMAND_TYPE ASC);