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

Preparing Siebel Tables and Views for Upgrade

Upgrades from: All Supported Siebel releases.

Environments: Development, production test, production.

Databases: All databases.

Platforms: 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.

Siebel Database Upgrade Guide Copyright © 2008, Oracle. All rights reserved.