Bookshelf Home | Contents | Index | PDF |
Configuring Siebel Business Applications > Configuring Tables > Manipulating Shapes and Lines in an Entity Relationship Designer > Customizing an Extension TableThis topic describes options to customize an extension table. It includes the following topics:
Creating a LONG Column on an Extension TableYou can create a LONG extension column. For more information, see Guidelines for Creating a LONG Column. To create a LONG column on an extension table
Manually Creating a One-to-One Extension TableAlthough you can manually create a one-to-one extension table, it is recommended that you use the New Table Wizard. For more information, see Guidelines for Creating a Custom One-to-One Extension Table and Using the New Table Wizard to Create a New Table. To manually create a one-to-one extension table
Modifying a Custom Extension Table or ColumnAfter you create a custom extension table or column, you can only modify the properties of the table or column. You can rename a column before you apply it to the Siebel Server. However, after you add the column or apply it to the Siebel Server, you cannot rename the column. You must deactivate the column and create a replacement extension column. Be careful if you modify the Physical Type property of a column. Depending on existing data in the column, it might not be possible to make a change. Siebel CRM does not support modifying a predefined base table or the columns of a predefined base table. You cannot modify the extension tables that come predefined with Siebel CRM. For more information, see How an Extension Table Stores Custom Data. To modify a custom extension table or column
Deleting a Custom Extension Table or ColumnYou can delete from the logical schema a custom extension table or column that you defined. Although deleting a table or column removes it from the logical schema in the Siebel repository, it does not remove it from the physical schema of the Siebel database. NOTE: You can only delete a custom extension column or table. You cannot delete a predefined table or the columns of a predefined table. After you delete an extension table, Siebel Tools does not delete any corresponding temporary columns in an interface table. You cannot use Siebel Tools to delete these columns. The columns will remain in the logical and physical schema. If a column is empty at the database level, and if the column is in the Siebel repository, and if the column is in the development environment but is not in the production environment, then your database administrator can use a database tool to remove a column that you do not require. However the database administrator must perform a full database backup before removing a column. The administrator must be careful when deleting a column because removing a column that Siebel CRM still references might require the administrator to revert to a full backup. Using the Siebel Database Configuration Wizard to run the Synchronize Schema Definition (ddlsync) utility does not delete a column that is inactive or that was deleted from the Siebel Repository. For more information, see Siebel Database Upgrade Guide. To delete a predefined extension column
|
Configuring Siebel Business Applications | Copyright © 2011, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |