Siebel Database Upgrade Guide > Preparing for Siebel Database Upgrade >

Preparing Siebel Custom Indexes for Upgrade

Environments: Development, production test, production.

Platforms: Windows, UNIX, IBM z/OS.

Consider the following guidelines when preparing custom indexes for upgrade:

• Custom indexes against extension columns on obsolete tables. If you have created custom indexes that use extension columns on obsolete tables, then you must migrate the data to new extension columns before upgrading the Siebel database. For assistance, create a service request (SR) on My Oracle Support, or contact your Oracle sales representative for Oracle Advanced Customer Services to request assistance from Oracle's Application Expert Services.
• Custom indexes that were not defined through Siebel Tools. Custom indexes created without using Siebel Tools are not included in the schema definition in the Siebel Repository. These indexes are dropped during the database upgrade. To preserve these indexes, add them to the Siebel Repository using Siebel Tools.
• Custom indexes on interface tables. Custom indexes on interface tables are not re-created during the upgrade. You must re-create them after the upgrade is complete.
• Custom indexes on base tables. The upgrade automatically removes and re-creates custom indexes on base tables.
• Custom indexes might need to be changed to reflect schema changes. Reevaluate custom indexes for applicability in the new release. They might no longer be needed due to schema changes in the new release.

For more information about custom indexes, see Configuring Siebel Business Applications. For information on schema changes in a release, see Siebel Data Model Reference on My Oracle Support.