Siebel Database Upgrade Guide > Basic Database Preparations for a Siebel Upgrade >

Preparing Siebel Tables and Views for Upgrade

Upgrades from: All Siebel releases.

Environments: Development, production test, production.

Databases: All databases.

Platforms: MS Windows, UNIX, IBM z/OS.

This topic is part of an upgrade process. See How to Perform a Siebel Database Upgrade.

To prepare tables and views for upgrade

1. Drop temporary tables and non-Siebel tables.

   If the upgrade process detects a column with a datatype not acceptable to Siebel tables, the upgrade will fail.

2. Disable customized triggers.

   You must re-create them after the upgrade.

3. Drop defined database views on Siebel tables.

   You must re-create them after the upgrade.

4. Export interface table data that you want to preserve.

   Interface tables are dropped and then re-created during upgrade. You can import the data after the upgrade.