Siebel Installation Guide for UNIX: Servers, Mobile Web Clients, Tools > Configuring the RDBMS > Configuring Oracle for Siebel Applications >
Guidelines for Overriding Oracle Default Table Spaces for Database Objects
Siebel Systems provides the option of overriding the default storage parameters for the table spaces in which specific tables or indexes are created. You created these table spaces using the instructions under Guidelines for Creating Oracle Table Spaces. To override these parameters, edit the ddl.ctl file located in the dbsrvr/oracle directory.
NOTE: The ddl.ctl file should be modified only by a qualified DBA.
For each Siebel object (table or index), you can specify a table space by using the
Table Space parameter. In the following example, the table space for the table
S_APP_VIEW is set to
DATA1. As provided by the Siebel application, the .ctl file does not set storage parameters for the objects it creates, so that they default to the parameters of the table spaces in which they are created. However, the
Table Space parameter only works under the following conditions:
- The table does not yet exist (for example, when you are performing a new database installation).
- The table needs to be rebuilt. In other words, there are schema changes made to the table such that an
ALTER TABLE command is not sufficient to implement the schema changes, requiring that the Siebel application drop and re-create the table.
The following example illustrates the use of the
Table Space parameter to set storage values for specific tables.
Type = Table
Name = S_APP_VIEW
Column 1 = ROW_ID VARCHAR(15) NOTNULL
Column 2 = CREATED TIMESTAMP NOTNULL DEFAULT %NOW%
Column 3 = CREATED_BY VARCHAR(15) NOTNULL
Column 4 = LAST UPD TIMESTAMP NOTNULL DEFAULT %NOW%
Column 5 = LAST_UPD_BY VARCHAR(15) NOTNULL
Column 6 = DCKING_NUM NUMERIC(22,7) DEFAULT 0
Column 7 = MODIFICATION_NUM NUMERIC(10,0) NOTNULL DEFAULT 0
Column 8 = CONFLICT_ID VARCHAR(15) NOTNULL DEFAULT '0'
Column 9 = NAME VARCHAR(50) NOTNULL
Column 10 = DESC_TEXT VARCHAR(255)
Column 11 = LOCAL_ACCESS_FLG CHAR(1)
Table Space = data1
If you use locally managed table spaces and want to change the storage parameters, see your Oracle technical documentation.
For an example of overriding the defaults for specific tables and indexes, see Guidelines for Overriding DB2 UDB Default Table Spaces for Database Objects.