my Siebel sandpit

The Siebel SIA 7.8 data model contains a total of 3,920 tables and 20,042 indexes.

For a vanilla Siebel installation, a minimum of two tablespaces (DATA and INDEX) are recommended.

The tablespaces should be locally managed with automatic extent allocation. This means that empty tables (3,339) and associated indexes only consume a single extent of 64KB.

After installation of the standard Siebel repository and seed data (ENU only), the data tablespace grew to 990MB (and indexes consumed 1815MB).

The tablespaces are set to autoextend because this is a development sandpit.

create tablespace siebel_data
datafile 'D:\oracle\product\10.2.0\oradata\DEMO\siebel_data01.dbf'
size 20M
autoextend on
next 1M
maxsize 2000M
extent management local 
autoallocate;