Bookshelf Home | Contents | Index | PDF | ![]() ![]() |
Siebel Database Upgrade Guide for DB2 UDB for z/OS > Postupgrade Tasks for a Siebel Development Environment > Reapplying Schema Customizations to the Siebel DatabaseEnvironments: Development environment only. This topic is part of an upgrade process. See How to Perform a Siebel Database Upgrade. In the current release, several tables are obsolete or have been replaced by new tables. If you added extension columns or foreign key (FK) columns to tables that are obsolete in the current release, you may want to reapply these changes to new tables that have replaced the obsolete tables. Reviewing Obsolete TablesThe upgrade process generates a report that you can review for information about obsolete tables that will help you decide whether or not you need to reapply schema customizations. This report, xtndobstbl.txt, lists the following:
Each obsolete table is listed with one of three codes:
If no tables are listed in xtndobstbl.txt, no action is required. If this file lists any tables, you can reapply their custom extensions and foreign key columns to tables in the current release using Siebel Tools. For further information on this task, see Configuring Siebel Business Applications. Table 20 lists examples of previously used tables that are inactive in the current release (you can no longer use these tables) and lists the suggested new tables to which custom extensions can be reapplied. The new tables are recommendations only; the tables that you choose to apply the extensions to might vary depending on their type and use. For help with validating the reapplication of extension columns and reviewing the steps necessary to migrate any extension column data to the new tables, create a service request (SR) on My Oracle Support. This data must be migrated during both the development and production environment upgrades. If you have created many custom extension columns on the tables In such cases, using Siebel Tools, you can manually create corresponding extension columns in the new target tables, and manually move the data to the new extension column on the new table before you continue migration of the application. Then review the business component configuration to make sure that the client will operate properly. You may need to do this in one of the following instances:
If you review the xtndobstbl.txt file after you run the business component migration utility, you will find a list of fields that require your attention. Table 21 lists examples of previously used tables that are no longer used in Release 8. Table 22 lists examples of tables which were unused in previous releases of Siebel Business Applications, but are used in the current release. |
![]() |
![]() ![]() |
Siebel Database Upgrade Guide for DB2 UDB for z/OS | Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |