Upgrading your State Store Oracle database
Perform these steps to upgrade the State Store database.
Procedure
- Back up your database.
- Access your Tridion Docs 14 installation media.
- 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 - 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 - 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 - Run the following SQL script as an administrator in order to revoke the privileges previously granted:
\Database\Scripts\Oracle\Shared\TCD_REVOKE.sql