Table Space Objects in Storage Control Files

Siebel tables are created in one of four table space sizes, 4 KB, 8KB, 16 KB, and 32 KB. Most tables are defined within a 4-KB table space.

Note: You can create new table spaces, and you can regroup tables as required for your enterprise.

The following example illustrates what the segmented Tablespace object for the Siebel Repository looks like in the storage control file.

[Object 4340]
Type       = Tablespace
Name       = H1004000
Database   = SIDB1004
LockSize   = Page
Bufferpool = BP1
Define     = No
Partitions = 0

This Tablespace object translates into the following DDL output:

CREATE TABLESPACE H1004000 IN SIDB1004 
USING STOGROUP SYSDEFLT 
PRIQTY   48 SECQTY 1440 FREEPAGE 0 PCTFREE 17 
DEFINE NO 
SEGSIZE 32 
BUFFERPOOL BP1 LOCKSIZE PAGE LOCKMAX 0 COMPRESS YES / 

Note: If you compare the input and the output, you can see that there are more options in the DDL output. These additional options occur because some values, such as FREEPAGE and PCTFREE, are taken from the default values.

Object numbering can change when you perform a storage control file extract. Therefore, object numbering can be different from one storage control file to another (except for default storage objects, for which numbering remains consistent).