Siebel Installation Guide for UNIX > Configuring the RDBMS > Configuring an Oracle Database for Siebel Business Applications >
Guidelines for Overriding Oracle Default Tablespaces for Database Objects
Siebel Business Applications provide the option of overriding the default storage parameters for the tablespaces in which specific tables or indexes are created. You created these tablespaces by using the instructions in Guidelines for Creating Oracle Tablespaces. To override these parameters, edit the ddl.ctl file located in the
NOTE: The ddl.ctl file must not be modified except by a qualified DBA.
For each Siebel object (table or index), you can specify a tablespace by using the Table Space parameter. In the following example, the tablespace for the table S_APP_VIEW is set to
This topic is part of Configuring an Oracle Database for Siebel Business Applications.
As provided by Siebel Business Applications, the .ctl file does not set storage parameters for the objects it creates, so that they default to the parameters of the tablespaces in which they are created. However, the Table Space parameter works only under the following conditions:
- When the table does not yet exist (for example, when you are performing a new database installation).
- When the table must be rebuilt. In other words, when schema changes are made to the table such that an ALTER TABLE command is insufficient to implement the schema changes. In this case, the table must be dropped and re-created.
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 tablespaces and want to change the storage parameters, then see Oracle Database technical documentation.
For an example (IBM DB2) of overriding the defaults for specific tables and indexes, see Guidelines for Overriding IBM DB2 Default Tablespaces for Database Objects.