Bookshelf Home | Contents | Index | PDF |
Siebel Installation Guide for UNIX > Configuring the RDBMS > Configuring an Oracle Database for Siebel Business Applications > Guidelines for Overriding Oracle Database Default Tablespaces for Database ObjectsSiebel 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 Database 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:
The following example illustrates the use of the Table Space parameter to set storage values for specific tables: [Object 219] 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. |
Siebel Installation Guide for UNIX | Copyright © 2017, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |