Bookshelf Home | Contents | Index | Search | PDF |
Siebel Server Installation Guide for Microsoft Windows > Creating the Oracle Database > Creating the Database >
Overriding Default Storage Parameters
Siebel Systems provides the option of overriding the default storage parameters, such as the tablespaces in which specific tables or indexes are created. To override these parameters, appropriately edit the
ddl.ctl
file located in thedbsrvr\
DBSRVR_PLATFORM
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 tablespace by using the
Table
Space
parameter. In the following example, the tablespace for the tableS_APP_VIEW
is set toDATA1.
As provided by Siebel, the.ctl
file does not set storage parameters for the objects it creates, so they will default to the parameters of the tablespaces in which they are created. However, theTable
Space
parameter will only work 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 recreate the table.The example below illustrates the use of the
Table Space
parameter to set storage values for specific tables.
[Object 219]
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 = data1If you use locally managed tablespaces and want to change the storage parameters, see your Oracle technical documentation.
Bookshelf Home | Contents | Index | Search | PDF |
Siebel Server Installation Guide for Microsoft Windows Published: 25 June 2003 |