Upgrading your State Store Oracle database

Perform these steps to upgrade the State Store database.

Procedure

  1. Back up your database.
  2. Access your Tridion Docs 14 installation media.
  3. Run the following SQL script as an administrator in order to grant the proper privileges to run the actual upgrade scripts:
    \Database\Scripts\Oracle\Shared\TCD_GRANT.sql
  4. E xecute the following SQL scripts:
    
    \Database\Scripts\Oracle\Shared\101\DP_STATE_SET_VERSION.sql
    \Database\Scripts\Oracle\Shared\1011\DP_STATE_SET_VERSION.sql
    \Database\Scripts\Oracle\Shared\110\DP_STATE_SET_VERSION.sql
  5. Regardless of the release from which you are upgrading, execute the following SQL scripts:
    \Database\Scripts\Oracle\Shared\CREATE_FK_INDEXES.sql
    \Database\Scripts\Oracle\Shared\111\DP_STATE_SET_VERSION.sql
  6. Run the following SQL script as an administrator in order to revoke the privileges previously granted:
    \Database\Scripts\Oracle\Shared\TCD_REVOKE.sql